INDEX_HISTOGRAM contains information from the ANALYZE INDEX ... VALIDATE STRUCTURE statement.
The ANALYZE INDEX ... VALIDATE STRUCTURE OFFLINE statement must be used in order 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 |
Oracle data dictionary views
Oracle dynamic performance views
No comments:
Post a Comment