Doc

    Name:   6index.sql

    Author Mark Gurry

    This simple script lists all tables that have more than 6 indexes.
#

ttitle  'Tables which have > 6 Indexes'
select  owner, table_name, count(*) 
  from  all_indexes
 where  owner not in ('SYS', 'SYSTEM')
 group  by owner, table_name 
having  count(*) > 6