Re: Which Index With This Constraint?

This gives you the index names of all primary keys:

select * from all_ind_columns where index_name in (select constraint_name from all_constraints where CONSTRAINT_TYPE = 'P');

It you want foreign keys use CONSTRAINT_TYPE = 'F'

... wrote in message <01be1c8c$f0cd7b30$69606b94_at_l000689>...
>How do I discover which index a given constraint uses?
>
>I defined indexes on specific tables and columns, then defined constraints
>which apply to the same columns. I think Oracle may manage to understand
>and use the existing indexes.
>
>How can I verify that? Can't find anything in dba_constraints,
>dba_indexes.
>
>Thanks for any info!
>
>A. Gordon
>aog_at_capgroup.com
Received on Tue Dec 01 1998 - 12:20:52 CST