> -----Original Message-----
> From: cemail2_at_sprintmail.com [mailto:cemail2_at_sprintmail.com]
>
> 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?
This query will show all indexes that do not enforce a constraint.
select owner, object_name
from dba_objects
where object_type = 'INDEX'
and object_id not in
(select enabled from sys.cdef$ where type# in (2, 3) and enabled is not
null)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jacques Kilchoer
INET: Jacques.Kilchoer_at_quest.com
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: ListGuru_at_fatcity.com (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).
Received on Fri Nov 22 2002 - 14:55:52 CST
