Updating statistics
In Oracle, system administration tasks include analyzing table commands. Analyze all tables to ensure that the Oracle Cost-Based Optimizer has up-to-date statistics.
- Sign into Control Desk.
- Open the Database Configuration application.
- From the Select Action menu, select Update Statistics, and then click OK to continue.