| Home / Oracle / Database / How to find tables without Indexes? |
How to find tables without Indexes? |
||||
Run following query in Query Editor.
USE <database_name>; GO SELECT SCHEMA_NAME(schema_id) AS schema_name ,name AS table_name FROM sys.tables WHERE OBJECTPROPERTY(OBJECT_ID,IsIndexed) = 0 ORDER BY schema_name, table_name; GO |
||||
Powered by
KBPublisher (Knowledge base software)
