Optimizer Statistics 

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

Prerequisite

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 its role.
Alert Monitoring is activated.

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	liveCache supports the Create new optimizer/space statistics (UPD_UNCOND) action only

Update the optimizer statistics at regular intervals. To do this, follow the procedure described in Updating the Optimizer Statistics.