Tool/SQL to find index that should be unique
Hello,
i found out that our erp software uses a lot of index but looks like everywhere theres is only one unique.
But i guess all indexes that contain all fields of the unique index should also be unique.
Otherwise oracle cant use them optimal, right?
Example:
INDEX_OWNER | INDEX_NAME | UNIQUENESS | STATUS | INDEX_TYPE | TEMPORARY | PARTITIONED | FUNCIDX_STATUS | JOIN_INDEX | COLUMNS |
---|---|---|---|---|---|---|---|---|---|
TEST_ERP_001 | PK_DOK | UNIQUE | VALID | NORMAL | N | NO | NO | DOKART, DOKNR | |
TEST_ERP_001 | I_DOK101 | NONUNIQUE | VALID | NORMAL | N | NO | NO | KADRNR, DOKART, DRKDEF | |
TEST_ERP_001 | I_DOK102 | NONUNIQUE | VALID | NORMAL | N | NO | NO | VADRNR, DOKART, DRKDEF |