select objectid, indexid, sum(*) as scans

from IndexCapture

group by objectid, indexid

In the above query change sum(*) to count(*).

This is a very nice article. But I agree with the other post that table size should be included into the calculation instead of just averagerecordsize.

AL