Hi folks

I just came across this script and one thing that puzzled me was this piece of code:

(CONVERT(Numeric(19,6), sys.dm_db_missing_index_group_stats.user_seeks)+CONVERT(Numeric(19,6), sys.dm_db_missing_index_group_stats.unique_compiles))*CONVERT(Numeric(19,6), sys.dm_db_missing_index_group_stats.avg_total_user_cost)*CONVERT(Numeric(19,6), sys.dm_db_missing_index_group_stats.avg_user_impact/100.0) AS Score

I usually saw the seeks added up with the scans, not with the unique compiles. Is this intended like this, is it a typo (+ instead of *) or it should have been user_scans instead of unique_compiles ?

Thanks,

Alin