题目内容
（请给出正确答案）
[主观题]
You are the administrator of a SQL Server 2000 computer. The server contains a database na
med Inventory. The database is configured as shown in the exhibit.
.jpg)
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.
如搜索结果不匹配，请 联系老师 获取答案
