Question
A _________________ index is the one which satisfies all the columns requested in the query without performing further lookup into the clustered index.
Answer: Option C
Was this answer helpful ?
CoveringA covered query is a query where all the columns in the query's result set are pulled from non-clustered indexes.
Was this answer helpful ?
More Questions on This Topic :
Question 1. What is the purpose of index in sql server ....
Question 3. How non clustered index point to the data? ....
Question 4. Which one is true about clustered index? ....
Question 5. What is true about indexes? ....
Submit Solution