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?
A. Change SUBSTRING(JobTitle,1, 1) = ‘C’ to JobTitle LIKE ‘C%’.
B. Partition the table and use the JobTitle column for the partition scheme.
C. Replace IX_Employees with a clustered index.
D. Change SUBSTRING (JobTitle, 1, 1) = ‘C’ to LEFT(JobTitle ,1) = ‘C’.