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
Explanation:Clustered indexes sort and store the data rows in the table based on their key values. 9. Which of the the following option is immediately applied to the index by using the SET clause in the ALTER INDEX statement ?