You are a database developer for an insurance company. You are informed that database operations, such as selects, inserts, and updates, are taking much longer than they were when the database was created a year ago. The previous developer added necessary indexes on the tables when the database was created. Since that time, additional tables and stored procedures have been added to the database. In addition, many of the queries are no longer used. You want to improve the response time of the database operations as quickly as possible. What should you do?

207.

You are a database developer for an insurance company.
You are informed that database operations, such as selects, inserts, and updates, are taking much longer than they were when the database was created a year ago.
The previous developer added necessary indexes on the tables when the database was created.
Since that time, additional tables and stored procedures have been added to the database.
In addition, many of the queries are no longer used. You want to improve the response time of the database operations as quickly as possible.

What should you do?

Execute the DBCC UPDATEUSAGE statement against the database to update the sysindexes system table.

Execute the DBCC SHOW_STATISTICS statement to find high-density indexes. Drop the high-density indexes.

Run the Index Tuning Wizard against a workload file to suggest indexes to create and drop the suggested indexes.

Use SQL profiler to find table scans. Add indexes to tables that were found to have table scans.

View Description

No description found.