Hi Everyone,

I am using SQL server2000. I need to check whether my SQL query Analyzer using the index? if it is picking the index, I need to know the % of use of the index and which index it is using? (like a index tuning wizard).

My SQL server login does not have the index tuning wizard enabled.

Thanks in advance.

Regards,
Sathieshkumar. R