You execute the following Transact-SQL statement. After populating the Employees table with 10,000 rows, you execute th

[answerhappygod]

You execute the following Transact-SQL statement.

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 1 (57.58 KiB) Viewed 108 times

You Execute The 2 (20.24 KiB) Viewed 108 times

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.