Determine if an Index has been used as a hint
Posted
by Joe Bloggs
on Stack Overflow
See other posts from Stack Overflow
or by Joe Bloggs
Published on 2010-05-26T22:00:07Z
Indexed on
2010/05/26
22:11 UTC
Read the original article
Hit count: 305
In SQL Server, there is the option to use query hints. eg
SELECT c.ContactID FROM Person.Contact c WITH (INDEX(AK_Contact_rowguid))
I am in the process of getting rid of unused indexes and was wondering how I could go about determining if an index was used as a query hint. Does anyone have suggestions on how I could do this?
Cheers, Joe
© Stack Overflow or respective owner