You need to reduce the amount of time it takes to execu…

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?

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.
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.