Database Tuning (MOSC)

MOSC Banner

in what order are table constraints evaluated?

edited Feb 20, 2012 7:33AM in Database Tuning (MOSC) 10 commentsAnswered
say I have 2 unique index constraints on my table, which constraint gets evaluated 1st?  There is overlap wrt CAR_IDENTIFIER_TYPE_ID field.
eg

CREATE UNIQUE INDEX CAR_ID_DATA_UN_IDX ON CAR_IDENTIFIER(LOWER(ID_DATA), LOWER(ID_QUALIFIER), CAR_IDENTIFIER_TYPE_ID)
;
CREATE UNIQUE INDEX CAR_ID_TYPE_UN_IDX ON CAR_IDENTIFIER(CAR_ID, CAR_IDENTIFIER_TYPE_ID)
;

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