You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. The database is configured as shown in the exhibit.
Users frequently need details about parts. Users search for data by using the following query.
SELECT Parts.SKU, Locations.Description, Manufacturer.Name,
INNER JOIN Manufacturer ON Parts.ManufacturerID=
INNER JOIN PartsLocation ON Parts.PartID = Parts.Location.PartsID
INNER JOIN Locations ON Parts.LocationID= Locations.LocationID
You need to accelerate query response time. What should you do?