[Oracle] 테이블 정보 알아보기(인덱스, 총ROWS등)

-- TABLE INDEX LIST

SELECT * FROM USER_INDEXES

WHERE TABLE_NAME = 'CETCINFLOG';

-- TABLE INDEX COLUMNS

SELECT * FROM USER_IND_COLUMNS

WHERE TABLE_NAME = 'CETCINFLOG';

-- TABLE STATISTICS

SELECT * FROM USER_TAB_STATISTICS -- NUM_ROWS

WHERE TABLE_NAME = 'CETCINFLOG';