Grassohopper

I'am sorry but I disagree with you. I still think that it's not normal.

If you look at the tblIndexUsageInfo table you will see that if the table as one index...

hi everybody.

I'm getting multiple rows per index with differing stats in tblIndexUsageInfo. Is this normal?

No it's not normal, see my earlier posts with the correction

K.

Hi everybody

Sql Frenzy

Apparently you didn't take into account my remark about the bad join into proc_filltblindexusageinfo. Am I wrong ?

Regards

Kristof

Hi everybody

maybe I am wrong but it seems to me that in the proc_filltblindexusageinfo it miss the join

spi.index_id=si.index_id on sys.dm_db_index_usage_stats

I think spi.object_id=so.object_id is not sufficient as it returns too...