in what order are table constraints evaluated?
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)
;
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)
;
0