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 INDEX table hint.
B.
Use the INDEX(0) table hint.
C.
Use the NOEXPAND table hint.
D.
Use the FORCESEEK table hint.
Explanation:
The FORCESEEK table hint forces the query optimizer to use only an index seek operation as the access path to the data in the table or view referenced in the query. You can use this table hint to override the default plan chosen by the query optimizer to avoid performance issues caused by an inefficient query plan.