Oracle 인덱스 용량산정

컬럼의 길이를 합치는 쿼리입니다

아래쿼리를 이용하여

예상되는 row의 개수에 곱해서 사용하세요.

 

SELECT  TA.COMMENTS, IDX.* FROM (

SELECT TABLE_NAME, INDEX_NAME,COUNT(COLUMN_LENGTH), SUM(COLUMN_LENGTH)

FROM USER_IND_COLUMNS

GROUP BY TABLE_NAME, INDEX_NAME 

ORDER BY TABLE_NAME, INDEX_NAME

) IDX

 , USER_TAB_COMMENTS TA

WHERE  IDX.TABLE_NAME = TA.TABLE_NAME   

ORDER BY IDX.TABLE_NAME, IDX.INDEX_NAME

;

SELECT  TA.COMMENTS, IDX.* FROM (

SELECT TABLE_NAME,COUNT(COLUMN_LENGTH), SUM(COLUMN_LENGTH)

FROM USER_IND_COLUMNS

GROUP BY TABLE_NAME

ORDER BY TABLE_NAME

) IDX

 , USER_TAB_COMMENTS TA

WHERE  IDX.TABLE_NAME = TA.TABLE_NAME   

ORDER BY IDX.TABLE_NAME

;