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?

Question

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?

Accepted Answer

D. Use the FORCESEEK table hint.

Answer

A. Use the INDEX table hint.

Answer

B. Use the INDEX(0) table hint.

Answer

C. Use the NOEXPAND table hint.

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…

Question

Options

How the community answered

Community Discussion