Re: HPL vs. Select Into

HPL in express mode is the fastest. test it you'll see. when you create the target tables make sure the first/next extent size are properly configured. and a checkpoint has been done before loading. Superboer. Tam OShanter schreef: > Hello, > > Looking at moving a table with many millions of rows to a new DB Space. > > Question being, will the move be faster using HPL that doing something like > "Select * from into......."? > > Why, why not? > > Thanks for the advice friends, > > Tam.