You are a database developer for your company’s SQL Server 2000 online transaction processing database. You have written several stored procedures that will produce critical sales reports. The stored procedures access existing tables, which are indexed. Before you put the stored procedures in the production environment, you want to ensure optimal performance of the new stored procedures. You also want to ensure that daily operations in the database are not adversely affected. What should you do?

238.

You are a database developer for your company’s SQL Server 2000 online transaction processing database.
You have written several stored procedures that will produce critical sales reports.
The stored procedures access existing tables, which are indexed. Before you put the stored procedures in the production environment, you want to ensure optimal performance of the new stored procedures.
You also want to ensure that daily operations in the database are not adversely affected.

What should you do?

Create a covering index for each query contained in the stored procedures.

For each query in the stored procedures, create an index that includes each column contained in the WHERE clause.

Use output from the Index Tuning Wizard to identify whether indexes should be added.

CREATE STATISTICS on all columns in the SELECT and WHERE clauses of each query.

View Description

No description found.