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 |
|---|---|---|---|
|
|
|
Number of times that one or more index keys is repeated in the table |
|
|
|
|
Number of index keys that are repeated that many times |