content_image/1012315.jpg
Figure 10 shows the information about the database objects that were changed. 

<img src='content_image/1012315.jpg'>

These dropped indexes indicate the cause for the many table scans and the reason for the impact on performance. 

## Setting the threshold value for SQL performance 

In IBM Data Server Manager, you can set the threshold value for SQL so that if any of the SQL is running for a long time, the user is notified. 

