Is there a way to avoid index scan in "Case" statements?

Question

Is there a way to avoid index scan in "Case" statements?

curious_sqldba

SSC-Dedicated

Points: 36502
More actions
May 14, 2011 at 11:19 pm

#236115

Is there a way to avoid index scan in "Case" statements? I have creating a covering index, still does clustered index scan..why?

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

Post the query, post the indexes

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

Syed Jahanzaib Bin hassan SSChampion Points: 11410 More actions · Answer 2

because your covering index does nt meet the requirement of the optimizer

Paste or attach the Actual or Execution plan of that query

My Blog
www.aureus-salah.com