You are a database developer. You plan to design a database solution by using SQL Server
2008. A frequently 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
full-table scans ·Allows the query optimizer to select the appropriate index. What should you
do?

A.
Use the FORCESEEK table hint.

B.
Use the NOEXPAND table hint.

C.
Use the INDEX(0) table hint.

D.
Use the INDEX table hint.