You are a database developer. You plan todesign a database solution by using SQL Server 2008.
A f requently used query takes very long to execute.
You discover that the query frequently uses full-table scans instead of indexes. This causes other queries that modify the table to be blocked.
The indexing strategy on the underlying tables that the query uses can change.
You need to design a solution that performs the following tasks:
Removes fulltable scans
Allows the query optimizer to select the appropriate index.
What should you do?
A.
Use the INDEX table hint.
B.
Use the INDEX(0) table hint.
C.
Use the NOEXPAND table hint.
D.
Use the FORCESEEK table hint.