TABLES WITH MORE THAN 5 INDEXES NOTES

 

Tabs With More Than 5 Inds

TABLES WITH MORE THAN 5 INDEXES NOTES:

Owner - Owner of the table

Table Name - Name of the table

Index Count - Number of indexes

select  OWNER,
 TABLE_NAME,
 COUNT(*) index_count
from   dba_indexes 
where   OWNER not in ('SYS','SYSTEM')
group   by OWNER, TABLE_NAME 
having  COUNT(*) > 5 
order  by COUNT(*) desc, OWNER, TABLE_NAME