Oracle索引状态查询&索引重建
时间：2021-07-01 10:21:17
帮助过：28人阅读
SELECT status, COUNT(*)
FROM dba_indexes
GROUP BY status
UNION
SELECT status, COUNT(*)
FROM dba_ind_partitions
GROUP BY status
UNION
SELECT status, COUNT(*)
FROM dba_ind_subpartitions
GROUP BY status
--重建索引
alter index pk_kc03 rebuild nologging;
or
alter index pk_kc03 rebuild
Oracle索引状态查询&索引重建
标签：color art 索引 union acl oracle索引 exe lte mil
