索引檢查

--檢查物件有效性
select object_name, object_type, status from user_objects where status <> 'VALID';


--索引列檢視
select  index_name, COLUMN_NAME
from user_ind_columns where table_name='SMSG_LOGS'  order by 1;
 
--檢查索引在哪些列上
select index_name, column_name , table_name from user_ind_columns  order by 1;

--檢查索引狀態及是否分割槽
select index_name, status,partitioned  from user_indexes where table_name='SMSG_LOGS'

--檢視索引佔用多大空間（M）;
 select sum(u.BYTES)/1024/1024 from user_segments u where u.segment_name='SYS_C0026464';