Analyze jobs allow you to evaluate statistics status and get statistic-related recommendations. Analyzing objects enables you to determine where additional statistics might be useful and identify existing statistics that are used frequently or are stale.
You can create new jobs, edit existing jobs, and abort jobs.
- Specify the database objects that will be analyzed by the job.
You can define the scope to include all objects or just a few.
- Select functions to be performed when the job is run, such as:
- Evaluate statistics usage and staleness and find missing statistics to collect
- Evaluate statistics to determine if they should be collected or deactivated
- Automate existing statistics
- Specify when and how often the job runs.
|Evaluate statistics usage and staleness and find missing statistics to collect||Determines which statistics are used, which statistics are stale, and which new statistics should be collected to help the Optimizer make better decisions.
The job report lists statistics that are stale and statistics that do not exist but the Optimizer would have used them if they had existed. If the Use DBQL option is enabled, the job report lists statistics that were used by the Optimizer.
After the job runs, collect recommendations are created.
|Evaluate statistics to determine if they should be collected or deactivated||Determines statistics that are useful to the Optimizer and recommends if statistics should be activated or deactivated.
The job report lists statistics that have not been used by the Optimizer for the specified period of time. These statistics can be flagged as inactive so that they are no longer collected by collect jobs. Also reports on statistics that have been flagged as inactive but that have been used by the Optimizer over the specified period.
After the job runs, deactivate and reactivate recommendations are created.
|Automate existing statistics||Reports on statistics that have not yet been automated.
The job report lists statistics that have not been automated with an option to include only new statistics since a particular date or only those statistics that are used as determined by the first function listed above.
After the job runs, automate recommendations are created.
When you specify the objects that will be analyzed by the job, you can use existing object lists and custom object lists. An object list is a list of database objects used for a job scope. An existing list is a custom list from another job or a list created outside of the Stats Manager portlet.