Get Indexes associated with an SQL Query

• abhilashca

  Mr or Mrs. 500

  Points: 508

  More actions

  June 18, 2009 at 5:46 am

  #95806

  Hi,

  I came across a strange situation.

  Is there any method to identify the Indexes associated with an SQL Query.

  Consider I have a tabel and an index. Say;

  Table1 - with 5 columns -Col1, Col2, Col3, Col4, Col5.

  Index1 - index mapping Col1, Col2

  And if Query1 on Table1 retrieves Col1 and Col2; then is there any method to show that my query Query1 is using an index Index1.

  Is that possible? Does such a query exists?

  Any help will be appreciated.

  Thanks

  ---
  .NET Developer
  Blog: Did you say .NET?[/url]
  Follow me on Twitter

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  June 18, 2009 at 5:54 am

  #1011655

  You can have a look at a query's execution plan. It'll show what indexes were used on that execution.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• abhilashca

  Mr or Mrs. 500

  Points: 508

  More actions

  June 18, 2009 at 7:22 am

  #1011723

  Hi,

  Thanks for the help.

  That worked.:w00t:

  Take care.

  ---
  .NET Developer
  Blog: Did you say .NET?[/url]
  Follow me on Twitter