Bad, invalid indexes
                                                 Last update (2008-03-31 20:23:19)
                                                                                                                   Date added (2008-02-21 13:23:23)

Summary
Displays bad, invalid indexes .
select owner||'.'||index_name||' STATUS='||status status
from dba_indexes where status='UNUSABLE'
union all
select owner||'.'||index_name||' DOMIDX_STATUS='||domidx_status status
from dba_indexes where domidx_status='IDXTYP_INVLD'
union all
select owner||'.'||index_name||' DOMIDX_OPSTATUS='||domidx_opstatus status
from dba_indexes where domidx_opstatus='FAILED'
union all
select owner||'.'||index_name||' FUNCIDX_STATUS='||funcidx_status status
from dba_indexes where funcidx_status='DISABLED';
Other links
Fast index rebuild
Find index skewed, rebuild
Find indexes browning, rebuild
Find unindexed foreign keys
Find unused indexes
Virtual Indexes
Reviews
Categories
Filters
Search