partition pruning test 1. 파티션테이블 생성 CREATE TABLE TB_TRD ( TRD_NO VARCHAR2(15), TRD_DT VARCHAR2(8), TRD_AMT NUMBER(15), CUST_ID VARCHAR2(10), PRDT_CD VARCHAR2(6), INST_ID VARCHAR2(50), INST_DTM DATE ) PARTITION BY RANGE(TRD_DT) ( PARTITION P_TB_TRD_201609 VALUES LESS THAN ('20160901'), PARTITION P_TB_TRD_201610 VALUES LESS THAN ('20161001'), PARTITION P_TB_TRD_201611 VALUES LESS THAN ('20161101'), PARTITION P_TB_TRD_20.. 더보기 이전 1 2 3 4 ··· 219 다음