You are mastering the company database. During the development, you find that Transact- SQL query below is running slowly:

SELECT VideoTitle, UpcNum, RetailPrice, Release Date FROM Srvideo. VideoTitle WITH (INDEX(0)) WHERE ReleaseDate BETWEEN '20050401' AND '20050510' A clustered index exists on the VideoTitle column. There is a nonclustered index on the ReleaseDate column which contains the UpcNum and RetailPrice columns. The result of the avg_fragmentation_in_percent is 30 percent, when you search the sys.dm_db_index_physical_stats dynamic management function (DMF) or the VideoTitle table, In order to find this method to solve this problem, which is the correct answer?

Question

You are mastering the company database. During the development, you find that Transact- SQL query below is running slowly:

SELECT VideoTitle, UpcNum, RetailPrice, Release Date FROM Srvideo. VideoTitle WITH (INDEX(0)) WHERE ReleaseDate BETWEEN '20050401' AND '20050510' A clustered index exists on the VideoTitle column. There is a nonclustered index on the ReleaseDate column which contains the UpcNum and RetailPrice columns. The result of the avg_fragmentation_in_percent is 30 percent, when you search the sys.dm_db_index_physical_stats dynamic management function (DMF) or the VideoTitle table, In order to find this method to solve this problem, which is the correct answer?

Accepted Answer

B. You should delete the query hint from the query.

Answer

A. You should reproduce the whole indexes on the VideoTitle table.

Answer

C. You should alter the query hint to force the optimizer to force a unclustered index seek.

Answer

D. You should Re-create the index on only the ReleaseDate column.

You are mastering the company database. During the development, you find that Transact- SQL query below is running slowly: SELECT VideoTitle, UpcNum, RetailPrice, Release Date FROM Srvideo…

Question

Options

How the community answered

Community Discussion