This may not do all you need but it will list out all the indexes in
dba_indexes that do not have a corresponding entry in the dba_constraints
table. You might have to put a few other criteria on it ... but this might
get you in the right direction.
select
a.owner,
a.index_name,
a.table_owner,
a.table_name
from
dba_indexes a
where
not exists (
select ''
from
dba_constraints b
where
a.owner = b.owner and
a.index_name = b.constraint_name)
-----Original Message-----
Sent: Friday, November 22, 2002 12:40 PM
To: Multiple recipients of list ORACLE-L
I am trying to find out what indexes are in the database only for
performance
reasons and do not enforce a constraint. What would be the query to do
that?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Lange
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
