Re: What's quicker, table to table insert or extract and sqlload?
Date: 1996/03/01
Message-ID: <313751A7.41C6_at_sgi.com>#1/1
Yuk Hon Johnny Chan wrote:
>
> :
> : NOTE : According to _Oracle : The Complete Reference_ (Koch&Looney), the
> : 'create table ... as select * from ...unrecoverable' option
> : suggested by Mr. Chan will be the fastest since no redo log
> : entries
> : are generated. It makes no mention of rollback segments. I
> : suspect
> : that since this is a DDL and the operation cannot be rolled back,
> : there is no use of rollback segments - any feedback on this ??
>
> that's correct...this should apply even to pre-7.2 versions. the
> unrecoverable option provides the additional benefit of no redo
> generation, which can be significant.
>
> Johnny Chan
> Independent Oracle Specialist
also what is not noted (at least in this fragment of the original) is that oracle has parallelized the 'create table as select', so on a smp box it can really scream !!!
-m -- -------------------------------------------------------------------------------- michael de young brown silicon graphics tel: 415 933 5507 network systems division fax: 415 390 6320 mikebr_at_sgi.com "that which does not kill you makes you stronger." - f. nietzsche "im not dead yet..." - m. python --------------------------------------------------------------------------------Received on Fri Mar 01 1996 - 00:00:00 CET