non_index.sql

Doc

    Name:   superind.sql

    Author Mark Gurry

    This simple script lists all indexes that have the same leading 
    column on a table and may be superfluous.

#

column table_owner format a20;
column table_name  format a26;
column column_name format a26;
ttitle 'Indexes which may be Superfluous'
select table_owner, table_name ,column_name from  all_ind_columns 
 where  column_position =1
 group  by table_owner, table_name , column_name
having  count(*) > 1;