"병렬쿼리 테스트"의 두 판 사이의 차이

1. 1. 초기화

TRUNCATE TABLE SCOTT.TB_ABC_CE;
PURGE DBA_RECYCLEBIN;
SELECT * FROM SCOTT.TB_ABC_CE;

1. 1. 병렬처리 설정

ALTER SESSION ENABLE PARALLEL DML;
ALTER SESSION SET DB_FILE_MULTIBLOCK_READ_COUNT=64;

1. 1. 테이블 속성 변경 NOLOGGING , PARALLEL

ALTER TABLE SCOTT.TB_ABC_CE NOLOGGING PARALLEL 32;

INSERT INTO /*+ APPEND_VALUES */ SCOTT.TB_ABC_CE  B   
SELECT /*+FULL(A) PARALLEL(A,32) */ *
  FROM SCOTT.TB_ABC A;
COMMIT;

1. 1. 속성 복구

ALTER TABLE SCOTT.TB_ABC_CE LOGGING NOPARALLEL;

1. 1. 인덱스 생성

ALTER SESSION SET DB_FILE_MULTIBLOCK_READ_COUNT=64;

CREATE INDEX GSSMADM.IX_IN_ABC_CE_01 ON SCOTT.TB_ABC_CE
       (SITE_CD, STKTAKE_NO, STKTAKE_SBJ_YN)
NOLOGGING
TABLESPACE TS_MIG
UNUSABLE
PARALLEL 4;

ALTER INDEX GSSMADM.IX_IN_ABC_CE_01 REBUILD NOLOGGING PARALLEL 4;

ALTER INDEX GSSMADM.PK_IN_ABC_CE REBUILD NOLOGGING PARALLEL 8;

ALTER INDEX GSSMADM.PK_IN_ABC_CE LOGGING NOPARALLEL;