Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Which Index With This Constraint?

Which Index With This Constraint?

From: ... <user_at_nowhere.net>
Date: 30 Nov 1998 18:12:08 GMT
Message-ID: <01be1c8c$f0cd7b30$69606b94@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!



    
  
  1.   Gordon
aog_at_capgroup.com



Received on Mon Nov 30 1998 - 12:12:08 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US