| 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 |