which is the correct answer?

You are mastering the company database. During the development, you find that TransactSQL 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?

You are mastering the company database. During the development, you find that TransactSQL 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?

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

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

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

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *