HPL vs. Select Into

Posted in 2006

Tam OShanter — Mon, 02 Oct 2006 17:09:43 GMT — source: Usenet: comp.databases.informix

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.

↪ replying to Tam OShanter

bozon — 2 Oct 2006 10:59:19 -0700 — source: Usenet: comp.databases.informix

insert into <new-table> select * from <old-table> ; is the proper SQL syntax and the only one Informix recognizes for insert into permanent tables. HPL will probably be faster, but if you make the destination table raw it will be pretty fast and it might be fast enough. Tam OShanter wrote: > 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.