Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-02 |
|
|
View PDF |
INDEX_HISTOGRAM
contains information from the ANALYZE INDEX ... VALIDATE STRUCTURE
statement.
Note:
TheANALYZE INDEX ... VALIDATE STRUCTURE OFFLINE
statement must be used in order to collect statistics.Column | Datatype | NULL | Description |
---|---|---|---|
REPEAT_COUNT |
NUMBER |
Number of times that one or more index keys is repeated in the table | |
KEYS_WITH_REPEAT_COUNT |
NUMBER |
Number of index keys that are repeated that many times |