Unanswered: Is it possible to find % of use of index in a query
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.