select t.index_name,
t.table_owner,
t.index_type,
t.tablespace_name,
t.partitioned,
t.status,
t.last_analyzed
from dba_indexes t
where t.table_owner = 'RMS'
查询索引,根据索引的状态和时间来判定索引是否失效.
select t.index_name,
t.table_owner,
t.index_type,
t.tablespace_name,
t.partitioned,
t.status,
t.last_analyzed
from dba_indexes t
where t.table_owner = 'RMS'
查询索引,根据索引的状态和时间来判定索引是否失效.