RE: make create table run faster?

If you already know the create table step is not the bottleneck, why are you
trying to make it faster? I would think you would want to make it more
efficient without slowing it down to the point that it becomes the
bottleneck, leaving as many resources as possible available for the parts
that are the bottleneck.

 

Now it might be possible to partition your queries in some fashion that
allows them to run in parallel as separate queries feeding separate
partitions so that you effectively construct the contents of the new table
in separate chunks without the overhead of parallel query and using separate
threads of non-parallel insert, but without understanding your source
queries in detail that is just speculation.

 

Curiously yours,

 

mwf

 

  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Guang Mei
Sent: Tuesday, April 28, 2009 1:12 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: make create table run faster?

 

Thanks Daniel, Mark and Vamshi for your suggestions. Yes, I have looked the
select statments extensively. The create table step is not the bottle neck
but I am wondering if I could just add some simple oracle parameters to make
it faster. Oracle has a bug when create table with partition or create
bitmap index using "parallel". For "normal" table and index the parallel
option seems fine. Anyway I will look into your suggestions.

Thanks.

 

Guang

 

<snip>

Other related posts: