You execute the following code.
After populating the Employees table with 10,000 rows, you execute the following query:
You need to reduce the amount of time it takes to execute the query.
What should you do?
![PrepAway - Latest Free Exam Questions & Answers](https://www.briefmenow.org/img/pa5.jpg)
A.
Partition the table and use the JobTitle column for the partition scheme.
B.
Change SUBSTRING(JobTitle,l,l) = ‘C to JobTitle LIKE ‘c%’
C.
Change SUBSTRING (JobTitle, 1,1] = ‘c’ to LEFT(JobTitle ,1) = ‘c’.
D.
Replace IX_Employees with a clustered index.
Correct
1
0