INDEX_HISTOGRAM
INDEX_HISTOGRAM contains information from the ANALYZE INDEX ... VALIDATE STRUCTURE statement.
Note: The ANALYZE INDEX ... VALIDATE STRUCTURE OFFLINE statement must be used 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 |