Modify Statistics

From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

The Modify Statistics Wizard lets you delete unwanted statistics history records from the statistics catalog tables. You can delete statistics history records that were written before a specific date, or records of a specific age. You can delete the records for an entire tablespace, index space, or index.

You should run the wizard regularly to clear outdated information from the statistics history catalog tables. Deleting outdated information from the statistics history catalog tables, improves the performance of processes that access data from those tables.

Platform Availability

To Run the Modify Statistics Utility

  1. Initiate a Modify Statistics action against a tablespace. For more information see Initiating an object operation.
  2. Use the following table as a guide to understanding and modifying settings in the Modify Statistics wizard:
Step Settings and tasks

1

Select tablespaces

Displays the available tablespaces.

Add

Opens theObject Selector Dialog Box.

Delete

Deletes the selected items.

2

Select indexes

Displays the available indexes.

Add

Opens the Index Selector Dialog Box.

Delete

Deletes the selected items.

3

Select indexspaces

Displays the available indexspaces.

Add

Opens the Indexspaces Selector dialog.

Delete

Deletes the selected items.

4

Delete history record(s) by

Age lets you delete history records by age, specifying a Number of Days between 1 and 32767. Date lets you delete all records written before a specified Date in eight digit format yyyymmdd (e.g. 20000218).

Delete options

Lets you choose among Delete All statistics rows, Delete Access path statistics rows, and Delete Space tuning statistics rows options

3. When ready, click Finish.