Doc

    Name:   noindex.sql

    Author Mark Gurry

    This simple script lists all tables that do not have any indexes.

#

ttitle  'Report on all Tables Without Indexes'
select  owner, table_name 
  from  all_tables
MINUS
select  owner, table_name 
  from  all_indexes;