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.
A. CLUSTERED
B. NON CLUSTERED
C. FULL TEXT
D. All of the mentioned
Answer:A
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.
A. CLUSTERED B. NON CLUSTERED C. FULL TEXT D. All of the mentioned