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.
It’s B
0
0
correct
0
0
I think it should be A.
JobTile is varchar(100).
0
0
I agree with Willem Jan, the answer should be B as the table isn’t big enough (10,000 rows) to consider table partitioning. If B is implemented, it will allow the query to use the non-clustered index.
0
0