Optimizer Statistics
In the Performance display of the Database Alert Monitor, you can find, among other things, information about the Optimizer statistics.
Prerequisites
Procedure
1. Start the Database Alert Monitor.
2. Choose <Name of the database connection> → Performance → Optimizer Statistics.
Result
Display |
Default for Alerts |
Last Collection |
Yellow alert, if the last update of the Optimizer statistics is older than 30 days Red alert, if the last update of the Optimizer statistics is older than 60 days |
Last Collection Type |
Type of update carried out |
Update the Optimizer statistics at regular intervals.
To do this, follow the procedure described in Scheduling the Updates of the SQL Optimizer Statistics.