RE: make create table run faster?

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Tue, 28 Apr 2009 13:33:15 -0400
Message-ID: <347D3FA99C874EDD975599B93EDCB6F0_at_rsiz.com>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Guang Mei
Sent: Tuesday, April 28, 2009 1:12 PM
To: oracle-l_at_freelists.org
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>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 28 2009 - 12:33:15 CDT