Oracle Server Manager User's Guide

The Optimizer Folder

When you click the Optimizer folder tab, the Optimizer folder opens and the Optimizer object list appears. The Optimizer object list contains information about the optimizer statistics generated for objects in the database. The Optimizer object list shows whether statistics have been generated for tables, clusters, and indexes in the database.

The Oracle optimizer chooses the execution plan for a SQL statement. When using the cost-based approach, the optimizer can utilize statistics for the objects accessed in the SQL statement. You generate these statistics using the ANALYZE command.

For information about the optimizer and generating statistics, see the Oracle7 Server Concepts and the ANALYZE command in the Oracle7 Server SQL Reference.

The following figure illustrates the Optimizer object list.

Figure 7 - 6. Optimizer Object List

Optimizer Object List

The columns of the Optimizer object list are described below:

Object The owner and name of the object.
Object Type Object type: Table, Cluster, or Index.
Statistics? Whether or not statistics have been generated for the object.

Object	The owner and name of the object.
Object Type	Object type: Table, Cluster, or Index.
Statistics?	Whether or not statistics have been generated for the object.