INDEX_OWNER | INDEX_NAME | UNIQUENESS | STATUS | INDEX_TYPE | TEMPORARY | PARTITIONED | FUNCIDX_STATUS | JOIN_INDEX | COLUMNS | COLUMN_EXPRESSION | |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | LOW_PRIVS | LOC_ID_PK | UNIQUE | VALID | NORMAL | N | NO | null | NO | LOCATION_ID | null |
2 | LOW_PRIVS | LOC_CITY_IX | NONUNIQUE | VALID | NORMAL | N | NO | null | NO | CITY | null |
3 | LOW_PRIVS | LOC_COUNTRY_IX | NONUNIQUE | VALID | NORMAL | N | NO | null | NO | COUNTRY_ID | null |
4 | LOW_PRIVS | LOC_STATE_PROVINCE_IX | NONUNIQUE | VALID | NORMAL | N | NO | null | NO | STATE_PROVINCE | null |