You are a database developer. You plan to design a database solution by using SQL Server
2008. The database supports a warehousing application and contains data from two
warehouses in a table named Product. The Product table contains a warehouse indicator
field named warehouse_id. The two warehouses are named Warehouse A and Warehouse
B.
Warehouse A contains 275,000 items and Warehouse B contains 55,000 items. The
solution uses a third-party application that runs on SQL Server 2008. The application uses a
stored procedure that returns the warehouse inventory based on the warehouse_id
parameter. Users report that occasionally, the system performance is unacceptable when
the Warehouse A inventory is queried. You cannot modify the stored procedures in the
application. You need to ensure acceptable performance when users query the inventory of
Warehouse A. What should you do?
Create a nonclustered index on the warehouse_id column.
A.
Create a clustered index on the warehouse_id column.
B.
Warehouse A contains 275,000 items and Warehouse B contains 55,000 items. The
solution uses a third-party application that runs on SQL Server 2008. The application uses a
stored procedure that returns the warehouse inventory based on the warehouse_id
parameter. Users report that occasionally, the system performance is unacceptable when
the Warehouse A inventory is queried. You cannot modify the stored procedures in the
application. You need to ensure acceptable performance when users query the inventory of
Warehouse A. What should you do?
Create a nonclustered index on the warehouse_id column.
C.
Create a plan guide that sets the MAXDOP query hint to 1.
D.
Create a plan guide that uses the OPTIMIZE FOR clause for Warehouse A.