1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | create table test_table_1 as select cast (dbms_random.string( 'A' ,50) as varchar2(50)) col01 , cast (dbms_random.string( 'A' ,50) as varchar2(50)) col02 , cast (dbms_random.string( 'A' ,50) as varchar2(50)) col03 , cast (dbms_random.string( 'A' ,50) as varchar2(50)) col04 , cast (dbms_random.string( 'A' ,50) as varchar2(50)) col05 , cast (dbms_random.string( 'A' ,50) as varchar2(50)) col06 , cast (dbms_random.string( 'A' ,50) as varchar2(50)) col07 , cast (dbms_random.string( 'A' ,50) as varchar2(50)) col08 , cast (dbms_random.string( 'A' ,50) as varchar2(50)) col09 , cast (dbms_random.string( 'A' ,50) as varchar2(50)) col10 from dual connect by level < 1000000 create table test_table_2 as select * from test_table_1 |
원하시는 row 수만큼(temp 파일 사용할 정도로 큰 테이블) 임시 테이블 생성하셔서 sort나 hash join 등등 테스트해보세요.