Optimizer Statistics 

In the Performance display of the liveCache Alert Monitors, you can find, among other things, information about the optimizer statistics.

Prerequisites

The user has been assigned a role in accordance with the authorization concept. You are in the user menu of the user with the authorizations that correspond to this role.

Procedure

       1.      Start the liveCache Alert Monitor.

       2.      Choose <Database Connection Name> → 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.