Name
ASSOCIATE STATISTICS
Synopsis
ASSOCIATE STATISTICS WITH
{COLUMNS [schema.] table_name.column[, [schema.] table_name.column...]
| FUNCTIONS [schema.]function[,[schema.]function...]
| PACKAGES [schema.]package[,[schema.]package...]
| INDEXES [schema.]index[,[schema.]index...]
}
{USING [schema.]statistics_type
| DEFAULT COST (cpu_cost,io_cost,network_cost)
| DEFAULT SELECTIVITY default_selectivity
| TYPES [schema.]type[,[schema.]type...]
}Defines how statistics are to be computed for the specified database objects. To remove or disassociate statistics from an object, use the DISASSOCIATE STATISTICS statement. New with Oracle8i.
Keywords
- COLUMNS
Specifies that a list of columns will be provided.
- FUNCTIONS
Specifies that one or more functions will be associated.
- PACKAGES
Specifies that one or more packages will be associated.
- INDEXES
Specifies that one or more indexes will be associated.
- USING statistics_type
Specifies the statistics type being associated.
- DEFAULT COST
Specifies that default costs will be provided for CPU, I/O, and the network. This keyword is not valid if the COLUMNS keyword is used.
- cpu_cost
Integer representing the CPU cost of a single execution or access.
- io_cost
Integer representing the I/O cost of a single execution or access.
- network_cost
Integer representing the network cost of a single execution or access.
- DEFAULT SELECTIVITY default_selectivity
Specifies an integer between 1 and 100, representing the default selectivity as a percentage. This keyword is not valid if ...