a) Clustered
b) Non Clustered
c) Covering
d) B-Tree
Answer: c
Explanation: A covered query is a query where all the columns in the query’s result set are pulled from non-clustered indexes.
Related Posts
In _______________ index instead of storing all the columns for a record together, each column is stored separately with all other rows in an index.
If an index is _________________ the metadata and statistics continue to exists
What are composite indexes?
Does index take space in the disk?:
What is true about indexes?
Which one is true about clustered index?
How non clustered index point to the data?
Join The Discussion