아래 파티션 테이블 생성 및 파티션 인덱스 생성을 하는 두개의 쿼리가 있는데 차이점이 어떻게 되나요.? 생성 결과는 같은건가요.? 서로 틀린부분 붉은색 표시했습니다. -- SCRIPT 1 CREATE TABLE TEST_A (COL1 NUMBER, COL2 NUMBER, COL3 VARCHAR2(20)) PARTITION BY RANGE (COL1, COL2) ( PARTITION PART_TEST_A_1 VALUES LESS THAN (10, 100), PARTITION PART_TEST_A_2 VALUES LESS THAN (20, 200), PARTITION PART_TEST_A_3 VALUES LESS THAN (30, 300), PARTITION PART_TEST_A_4 VALUES LESS THAN (40, 400) );
CREATE UNIQUE INDEX IX_TEST_A ON TEST_A(COL1, COL2) LOCAL( PARTITION IX_TEST_A_1, PARTITION IX_TEST_A_2, PARTITION IX_TEST_A_3, PARTITION IX_TEST_A_4 );
ALTER TABLE TEST_A ADD ( CONSTRAINT PK_TEST_A PRIMARY KEY (COL1, COL2) USING INDEX LOCAL ); -- SCRIPT 2
CREATE TABLE TEST_A (COL1 NUMBER, COL2 NUMBER, COL3 VARCHAR2(20)) PARTITION BY RANGE (COL1, COL2) ( PARTITION PART_TEST_A_1 VALUES LESS THAN (10, 100), PARTITION PART_TEST_A_2 VALUES LESS THAN (20, 200), PARTITION PART_TEST_A_3 VALUES LESS THAN (30, 300), PARTITION PART_TEST_A_4 VALUES LESS THAN (40, 400) );
CREATE INDEX IX_TEST_A ON TEST_A(COL1, COL2) LOCAL( PARTITION IX_TEST_A_1, PARTITION IX_TEST_A_2, PARTITION IX_TEST_A_3, PARTITION IX_TEST_A_4 );
ALTER TABLE TEST_A ADD ( CONSTRAINT PK_TEST_A PRIMARY KEY (COL1, COL2) );
