dba_ind_partitions中index的紀錄和dba_indexes是否重複

答案是肯定的，與DBA_TABLES和DBA_TAB_PARTITIONS不同，DBA_IND_PARTITIONS是DBA_INDEXES裡面被分割槽的indexes內容的複製。 SQL> select count(0) from dba_indexes where table_name like '%MV' and table_owner='ADWGD'; COUNT(0) ---------- 2152 SQL> select COUNT(distinct(index_name)) from dba_ind_partitions where index_owner='ADWGD'; COUNT(DISTINCT(INDEX_NAME)) --------------------------- 2411 SQL> select distinct(index_name) from dba_ind_partitions where index_owner='ADWGD' 2 minus 3 select index_name from dba_indexes where table_name like '%MV' and table_owner='ADWGD'; INDEX_NAME -------------------------------------------------------------------------------- 。。。。。。 259 rows selected. 259= 2152 - 2411， 而且select出來的索引都為非分割槽索引。[@more@]