Data from two storerooms are contained in the database in a table named Manufacures. The two storerooms are respectively called Storeroom1 and Storeroom2. And the database supports a warehousing application. A storeroom indicator field named storeroom_id is contained in the Manufacture table. Storeroom1 includes 275,000 items and Storeroom2 includes 55,000 items. A third-party application is used by the solutions. And the third-party application runs on SQL Server 2008 and uses a stored procedure that returns the storeroom inventory based on the warehouse_id parameter. You notice that when users query the storeroom1 inventory, users sometimes experience poor system performance. But the stored procedures cannot be modified in the application. So when the inventory of Storeroom1 is quried, what should you do to ensure the system performance?
A.
On the storeroom_id column, a clustered index should be created.
B.
On the storeroom_id column, a non-clustered index should be created.
C.
A plan guide should be created that the MAXDOP query hint is set to 1.
D.
A plan guide that uses the OPTIMIZE FOR clause for Storeroom1 should be created.