You create a table named Customers by using the following code segment: You create a non-clustered index named IX_Name

[answerhappygod]

You create a table named Customers by using the following code segment:

You create a non-clustered index named IX_Name on the name column.
You write the following query to retrieve all of the customers that have a name that starts with the letters SMI:

You discover that the query performs a table scan.
You need to ensure that the query uses the index.
What should you do?

You Create A Ta 1 (14.35 KiB) Viewed 89 times

You Create A Ta 2 (12.64 KiB) Viewed 89 times

A. Replace LEFT(name,3) = 'smi' by using name like 'smi%'
B. Replace LEFT(name,3) = 'smi' by using substring(name,l,3) = 'smi'
C. Recreate IX_Name as a unique index
D. Recreate IX Name as a clustered index