What should you do?

You execute the following code:

You need to reduce the amount of time it takes to execute the query.
What should you do?
A. Replace LEFT (CustomerName, 1) = ‘a’ with CustomerName LIKE ‘a%’.
B. Partition the table and use the CustomerName column for the partition scheme.
C. Replace LEFT (CustomerName, 1) = ‘a’ with SUBSTRING (CustomerName, 1/1) = ‘a’.
D. Replace IX_CustomerName with a clustered index.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.