You have a table named Table1. A sample of the data in Table1 is shown in the following table.
There is a defined nonclustered index on the SalesOrderNumber column.
The following query executes against the table:
WHERE ‘SO3’ = LEFT(SalesOrderNumber,3)
You need to minimize the amount page I/O that is generated when the query runs.
What should you do?
A. Use a query hint.
B. Add a non-filtered index.
C. Rewrite the WHERE clause to use a LIKE statement.
D. Rewrite the WHERE clause to use a substring function on the SalesOrderNumber column.
