You need to reduce the amount of time it takes to execute the query

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.



Leave a Reply 6

Your email address will not be published. Required fields are marked *


annonymous

annonymous

If the backslash in option B is a typo then B es the correct answer.

Mido

Mido

Yes it is B
And it is duplicates to question 60