You work as the database administrator at Domain.com. All servers on the Domain.com network run Windows Server 2003 and all database servers run SQL Server 2005. The Domain.com network contains a database server named Certkiller -DB01 B01. Certkiller -DB01 hosts a database named CK_Sales that stores sales data for the company. There is at least one index on each table in the CK_Sales database. The tables in the CK_Sales database are shown in the following database diagram.

Domain.com users in the Finance department run several stored procedures against he CK_Sales database to create month end reports. You have recently altered some of the stored procedures. How Finance department users complain that the month-end reports take longer to create. You need to improve the performance of the stored procedures.
exhibit What should you do? (Each correct answer presents part of the solution. Choose two.)