#완성 SELECT A.TABLE_OWNER, A.TABLE_NAME, B.INDEX_NAME, B.INDEX_TYPE, B.GLOBAL_STATS, B.PARTITIONED FROM DBA_TAB_PARTITIONS A, (SELECT * FROM DBA_INDEXES WHERE OWNER NOT IN ('SYS','SYSTEM') AND PARTITIONED='NO') B -- NO : 글로벌 YES : 로컬 , GLOBAL_STATS : 통계정보시 해당 인덱스도 분석을 하겠냐(YES) WHERE B.TABLE_NAME = A.TABLE_NAME AND B.OWNER = A.TABLE_OWNER GROUP BY A.TABLE_OWNER, A.TABLE_NAME, B.INDEX_NAME, B.INDEX..