You have a Microsoft SQL Azure database that contains a table named Employees. You create a non-clustered index named E

[answerhappygod]

You have a Microsoft SQL Azure database that contains a table named Employees.

You create a non-clustered index named EmployeeName on the name column.

You write the following query to retrieve all of the employees that have a name that starts with the letters JOH:
You discover that the query performs a table scan.
You need to ensure that the query uses EmployeeName.
What should you do?

You Have A Micr 1 (15 KiB) Viewed 100 times

You Have A Micr 2 (11.81 KiB) Viewed 100 times

A. Recreate EmployeeName as a unique index
B. Recreate EmployeeName as a clustered index
C. Replace LEFT(name,3) = 'JOH' by using name like 'JOH%'
D. Replace LEFT(name,3) = 'JOH' by using substring(name, 1, 3) = 'JOH'