Microsoft
70-459 · Question #113
You execute the following code: You create a nonclustered index named IXCustomerName on the CustomerName column. You execute the following query: You need to reduce the amount of time it takes to…
Sign in or unlock 70-459 to reveal the answer and full explanation for question #113. The question stem and answer options stay visible for context.
Question
You execute the following code: You create a nonclustered index named IXCustomerName on the CustomerName column. You execute the following query: You need to reduce the amount of time it takes to execute the query, What should you do?
Options
- APartition the table and use the CustomerName column for the partition scheme.
- BReplace IX_CustomerName with a clustered index.
- CReplace LEFT(CustomerName ,1) = 'a' with CustomerName LIKE 'a%'.
- DReplace LEFT(CustomerName ,1) = 'a' with SUBSTRING(CustomerName ,1,1) - 'a'.
Unlock 70-459 to see the answer
You've previewed enough free 70-459 questions. Unlock 70-459 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.