How to set manual index priority in a select query

• balajisrm

  Right there with Babe

  Points: 723

  More actions

  June 13, 2012 at 9:07 pm

  #262397

  I have a table which has some 3 indexes (1 clustered and 2 non clustered) . is there any possibility that i can make a particular index column to be considered first to scan. if possible kindly tell me how to do it?.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  June 14, 2012 at 2:48 am

  #1500833

  Yes, but I recommend you don't unless you know exactly whey the optimiser is not choosing the index you want and you are absolutely and copletely sure you know better than the optimiser which indexes work for this query.

  Any chance of posting the query and the index definitions?

  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