You execute the following Transact-SQL statement. After populating the Employees table with 10,000 rows, you execute th
Posted: Mon Oct 17, 2022 4:50 pm
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?
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.
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 109 times
- You Execute The 2 (20.24 KiB) Viewed 109 times
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.