Re: What's quicker, table to table insert or extract and sqlload?

In article <4ep8qt$2sj_at_hpcc48.corp.hp.com>

           jychan_at_corp.hp.com "Yuk Hon Johnny Chan" writes:
>
> Andy Hardy (aph_at_ahardy.demon.co.uk) wrote:
> : Hi,
 

> : I've a 6 million row table that needs to be copied to another, to
> : produce identical copies.
 

> : I'm contemplating either performing a very large insert (will I have
> : the rollback to support it!) or extracting the first table to a file
> : for subsequent loading by sqlload.
 

> : Any thoughts or suggestions?
>
> My strong suspicion (i have no datapoints to back this claim up) is that
> your fastest method is to "create table ... as select * from ...
> unrecoverable...". The unrecoverable piece is only available in 7.2+.

Unfortunately, I'm a 7.1.4 kind of a guy!  

> a close second (though a bit complicated) would be extracting the first
> table to a pipe (in UNIX) and have loader read that pipe as the input file
> (using direct loader option, of course).

Hm... I'll consider that.

Thanks for the reply,

Andy

-- 
Andy Hardy (Internet: aph_at_ahardy.demon.co.uk, CIS: 100015,2603)
PGP key available on request
===============================================================
I'm a creationist; I refuse to believe that I could have evolved from man.