The following SELECT statement shows the number of index accesses occurring on a particular object:
SELECT IndexNumber, AccessCount FROM DBC.IndexUseCountV WHERE DatabaseName = 'Personnel' AND TableName = 'Employee';
Result:
IndexNumber AccessCount ----------- -------------------------- 1 1