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.

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.

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.