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 -> Re: all foreign key should have index?

Re: all foreign key should have index?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 30 Jan 2006 06:51:35 -0800
Message-ID: <1138632695.296886.61620@z14g2000cwz.googlegroups.com> 





Only indexes used to support PK and UK constraints can be determined by
querying dba_constraints directly.  The indexes that exist to support
FK constraints, if they exist, are not available without doing a little
more work.  Unfortunately, the Reference manual (9.2)does not list the
fact the index_name is only populated for PK and UK constraints.



Queries to find these indexes have been posted in the past.  Try
searching the archives.



HTH -- Mark D Powell --
Received on Mon Jan 30 2006 - 08:51:35 CST












Original text of this message













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