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.

Explanation: