how to tell if an index is being used in a query...

• Marysa

  Ten Centuries

  Points: 1023

  More actions

  October 20, 2004 at 8:34 am

  #361366

  Is there a way other than the Index tuner to tell if an index is being used in a query?

• iLoveSQL

  SSCrazy

  Points: 2888

  More actions

  October 20, 2004 at 9:04 am

  #527320

  You mean if a query uses a particular index?

  If that is the case, under SQL analyzer and execution plan (Ctrl + L) fuction