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 -> Is index used for constraint enforcement?

Is index used for constraint enforcement?

From: Marko Kimpel <marko.kimpel_at_gmx.de>
Date: 2 Sep 2003 08:32:30 -0700
Message-ID: <2c165149.0309020732.380ec0dd@posting.google.com> 





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
Received on Tue Sep 02 2003 - 10:32:30 CDT












Original text of this message













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