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: 310

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

Related posts about sql-server-2008

Related posts about index