Purpose |
Procedures |
Description |
Gather statistics |
GATHER_INDEX_STATS
GATHER_TABLE_STATS
GATHER_SCHEMA_STATS
GATHER_DATABASE_STATS
GENERATE_STATS
|
The GATHER_STATS packages collect statistics from tables and indexes. The GENERATE_STATS procedure generates the statistics for an object from a group of related objects. |
Delete statistics |
DELETE_COLUMN_STATISTICS
DELETE_TABLE_STATISTICS
DELETE_INDEX_STATISTICS
DELETE_SCHEMA_STATISTICS
DELETE_DATABASE_STATISTICS
|
Removes any existing statistics from the data dictionary or an external table, if specified. |
Use external table to store statistics |
CREATE_STAT_TABLE
DROP_STAT_TABLE |
Creates and drops an external table to store statistics. |
Export statistics |
EXPORT_COLUMN_STATISTICS
EXPORT_TABLE_STATISTICS
EXPORT_INDEX_STATISTICS
EXPORT_SCHEMA_STATISTICS
EXPORT_DATABASE_STATISTICS
|
Exports statistics to an external table from the data dictionary. |
Import statistics |
IMPORT_COLUMN_STATISTICS
IMPORT_TABLE_STATISTICS
IMPORT_INDEX_STATISTICS
IMPORT_SCHEMA_STATISTICS
IMPORT_DATABASE_STATISTICS
|
Imports statistics from an external table to the data dictionary. |
Convert values |
CONVERT_RAW_VALUE
PREPARE_COLUMN_VALUES
|
Converts values to (PREPARE_COLUMN_VALUE ) and from (CONVERT_RAW_VALU E), the Oracle internal format for statistics. |
Set statistics |
SET_COLUMN_STATS
SET_INDEX_STATS SET_TABLE_STATS |
You can use these procedures to set values for statistics. Use only when you have a complete understanding of how statistics are used by the optimizer. |
Get statistics |
GET_COLUMN_STATS GET_INDEX_STATS GET_TABLE_STATS |
Used to retrieve values from statistics tables. |