• Would someone kindly elaborate on sys.dm_db_missing_index_group_stats

    column user_scans. I tried all kinds of good and bad things in queries to bump user_scans in statistics and it doesnt budge. WHat will cause it to be non-zero?