Optimizer Statistics

In the Performance display of the Database Alert Monitor, you can find, among other things, information about the Optimizer statistics.

Prerequisites

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.