> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>
> 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)
