Table: DBA_IND_COLUMNS
COLUMNs comprising INDEXes on all TABLEs and CLUSTERs
| Column Name | Description |
|---|---|
| CHAR_LENGTH | Maximum length of the column or attribute, in characters |
| COLUMN_LENGTH | Maximum length of the column or attribute, in bytes |
| COLUMN_NAME | Column name or attribute of object column |
| COLUMN_POSITION | Position of column or attribute within index |
| DESCEND | DESC if this column is sorted in descending order on disk, otherwise ASC |
| INDEX_NAME | Index name |
| INDEX_OWNER | Index owner |
| TABLE_NAME | Table or cluster name |
| TABLE_OWNER | Table or cluster owner |