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?