Re: Very Large Table Split

Curt van den Heuvel (heuvelc@primenet.com) wrote: : I have a very large table (27,000,000+ rows) that needs to be split : into at least three parts. Is there a quicker way to accomplish this : than using an unload/load? (I figure that the unload/load will take : between 30 and 40 hours to run.) : Thanks, : Curt I'm assuming that you mean creating 3 separate tables from the one table when you say "split into at least three parts"? If that's the case, then the quickest way is to use an "insert into select " if you can turn transaction logging off in your database. Example: insert into table1 select column1, column2, column3 from large_table; insert into table2 select column4, column5, etc from large_table; insert into table3 select columnX, etc from large_table; You can even run all three in parallel. Also make sure that the indexes aren't created until after the tables are done being loaded. ---------------------------- Stefanie Vario ZenaComp Incorporated svario@zenacomp.com -- Stefanie Vario ZenaComp Incorporated svario@zenacomp.com