Database Tuning (MOSC)

MOSC Banner

Tool/SQL to find index that should be unique

edited May 23, 2018 5:33AM in Database Tuning (MOSC) 12 commentsAnswered ✓

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_OWNERINDEX_NAMEUNIQUENESSSTATUSINDEX_TYPETEMPORARYPARTITIONEDFUNCIDX_STATUSJOIN_INDEXCOLUMNS
TEST_ERP_001PK_DOKUNIQUEVALIDNORMALNNO NODOKART, DOKNR
TEST_ERP_001I_DOK101NONUNIQUEVALIDNORMALNNO NOKADRNR, DOKART, DRKDEF
TEST_ERP_001I_DOK102NONUNIQUEVALIDNORMALNNO NOVADRNR, DOKART, DRKDEF

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center