Explanation:A nonpartitioned clustered index and the base table always reside in the same filegroup. 7. Specifying the order in which key values are stored in an index is useful when queries referencing the table have :
A. ORDER BY clauses
B. SORT clauses
C. WHERE clauses
D. None of the mentioned
Answer:A
Explanation:A nonpartitioned clustered index and the base table always reside in the same filegroup. 7. Specifying the order in which key values are stored in an index is useful when queries referencing the table have :
A. ORDER BY clauses B. SORT clauses C. WHERE clauses D. None of the mentioned
Explanation: In these cases, the index can remove the need for a SORT operator in the query plan; therefore, this makes the query more efficient. 8. Every table should have a ________ index defined on the column, or columns.