What should you do?

You are a database administrator for AIOTestKing.com. The company uses a database named VideoStore. The SQL statements used to create the Sales table in the VideoStore database, an existing index, and the two most common queries executed against this table are shown in the exhibit. (Click the Exhibit button.)

The existing indexes have just been rebuilt. The VideoID and VideoTitle fields are highly selective. The RetailPrice, WholesalePrice and Genre fields have low selectivity. You need to optimize the performance of both queries while minimizing the size of the index. What should you do?

You are a database administrator for AIOTestKing.com. The company uses a database named VideoStore. The SQL statements used to create the Sales table in the VideoStore database, an existing index, and the two most common queries executed against this table are shown in the exhibit. (Click the Exhibit button.)

The existing indexes have just been rebuilt. The VideoID and VideoTitle fields are highly selective. The RetailPrice, WholesalePrice and Genre fields have low selectivity. You need to optimize the performance of both queries while minimizing the size of the index. What should you do?

A.
Create a clustered index on the VideoTitle and RetailPrice columns.

B.
Create a nonclustered index on the Barcode and VideoID fields and include the WholesalePrice and Genre fields.

C.
Create a nonclustered index on the VideoTitle, Barcode, VideoID, WholesalePrice, and Genre fields.

D.
Drop the clustered index on the VideoTitle field. Create a nonclustered index on the VideoTitle field.

E.
Alter the existing nonclustered index by using the REORGANIZE option.



Leave a Reply 0

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