|
Each row in the SYSPHYSIDX system view defines a physical index in the database. The underlying system table for this view is ISYSPHYSIDX.
| Column name | Column type | Column constraint |
|---|---|---|
| table_id | UNSIGNED INT | NOT NULL |
| phys_index_id | UNSIGNED INT | NOT NULL |
| root | INTEGER | NOT NULL |
| key_value_count | UNSIGNED INT | NOT NULL |
| leaf_page_count | UNSIGNED INT | NOT NULL |
| depth | UNSIGNED SMALLINT | NOT NULL |
| max_key_distance | UNSIGNED INT | NOT NULL |
| seq_transitions | UNSIGNED INT | NOT NULL |
| rand_transitions | UNSIGNED INT | NOT NULL |
| rand_distance | UNSIGNED INT | NOT NULL |
| allocation_bitmap | LONG VARBIT | |
| long_value_bitmap | LONG VARBIT |
table_id The object ID of the table to which the index corresponds.
phys_index_id The unique number of the physical index within its table.
root Identifies the location of the root page of the physical index in the database file.
key_value_count The number of distinct key values in the index.
leaf_page_count The number of leaf index pages.
depth The depth (number of levels) of the physical index.
max_key_distance For system use only.
seq_transitions For system use only.
rand_transitions For system use only.
rand_distance For system use only.
allocation_bitmap For system use only.
long_value_bitmap For system use only.
PRIMARY KEY (table_id, phys_index_id)