Microsoft
70-451 · Question #40
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…
The correct answer is C. Rewrite the WHERE clause to use a LIKE statement. See the full explanation below for the reasoning.
Question
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?
Options
- AUse a query hint.
- BAdd a non-filtered index.
- CRewrite the WHERE clause to use a LIKE statement.
- DRewrite the WHERE clause to use a substring function on the SalesOrderNumber column.
How the community answered
(47 responses)- A11% (5)
- B4% (2)
- C70% (33)
- D15% (7)
Community Discussion
No community discussion yet for this question.