You are the administrator of a SQL Server 2000 computer. The server contains a database na

Users frequently need details about parts. Users search for data by using the following query.

SELECT Parts.SKU, Locations.Description, Manufacturer.Name,

PartsLocations.Qty, PartsLocations.LastInventoried

FROM Parts

INNER JOIN Manufacturer ON Parts.ManufacturerID=

Manufacturer.ManufacturerID

INNER JOIN PartsLocation ON Parts.PartID = Parts.Location.PartsID

INNER JOIN Locations ON Parts.LocationID= Locations.LocationID

WHERE SKU？

You need to accelerate query response time. What should you do？

A．Create a parameterised stored procedure to retrieve the data.

B．Create a denormalized table that is maintained by triggers.

C．Use ad hoc queries to retrieve the data.

D．Create a nonclustered index on the primary key of each table.