Friday, August 3, 2018

How to find all tables which are not indexed in a oracle database

Find all the tables which are not indexed:

SELECT t.TABLE_NAME
  FROM DBA_TABLES t
  LEFT OUTER JOIN (SELECT DISTINCT TABLE_NAME
                     FROM DBA_INDEXES) i
    ON i.TABLE_NAME = t.TABLE_NAME
  WHERE i.TABLE_NAME IS NULL;

No comments:

Post a Comment