Randheer (2/17/2011)
What are criteria to define covering index and how we create it?
Please provide some details for this question.
For Sql Server Interview Questions and Answer
http://sqlserverquest.blogspot.com[/url%5D%5B/quote%5D
It has to cover the query, and it's created the same way you create any index. I guess I'm not clear on what you're asking here. The only difference between a covering index and a non-covering index is the match-up between columns in the query and columns in the index being complete or incomplete.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon