You are developing a database application by using Microsoft SQL Server 2012. An application that uses a database begins to run slowly. Your investigation shows the root cause is a query against a read-only table that has a clustered index. The query returns the following six columns:

One column in its WHERE clause contained in a non-clustered index

Four additional columns

One COUNT (*) column based on a grouping of the four additional

columns You need to optimize the statement. What should you do?

Question

You are developing a database application by using Microsoft SQL Server 2012. An application that uses a database begins to run slowly. Your investigation shows the root cause is a query against a read-only table that has a clustered index. The query returns the following six columns:

One column in its WHERE clause contained in a non-clustered index
Four additional columns
One COUNT (*) column based on a grouping of the four additional

columns You need to optimize the statement. What should you do?

Accepted Answer

F. Add a columnstore index to cover the query.

Answer

A. Add a HASH hint to the query.

Answer

B. Add a LOOP hint to the query.

Answer

C. Add a FORCESEEK hint to the query.

Answer

D. Add an INCLUDE clause to the index.

Answer

E. Add a FORCESCAN hint to the Attach query.

Answer

G. Enable the optimize for ad hoc workloads option.

Answer

H. Cover the unique clustered index with a columnstore index.

Answer

J. Include a SET STATISTICS PROFILE ON statement before you run the query.

You are developing a database application by using Microsoft SQL Server 2012. An application that uses a database begins to run slowly. Your investigation shows the root cause is a query against a…

Question

Options

How the community answered

Community Discussion