Re: Is index used for constraint enforcement?

Go back and look at USER_CONSTRAINTS again. If the constraint requires an index, then the INDEX_OWNER, INDEX_NAME columns of USER_CONSTRAINTS will tell you which index that specific constraint uses.

HTH,
Brian

Marko Kimpel wrote:
>
> I'm using Oracle 8.1.7.
>
> How can I determine if a given table index is required for enforcement
> of a constraint (e.g. unique or pk constraint)? Didn't find usefull
> information in USER_INDEXES or USER_CONSTRAINTS.
>
> (Assuming the same name of index and constraint does not work since
> Oracle may use an existing index when creating an constraint and thus
> use different names.)
>
> Marko

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"