RE: make create table run faster?

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
  • To: "gmei@xxxxxxxxxxxxxx" <gmei@xxxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 28 Apr 2009 12:04:51 -0400

Nologging is redundant on a noarchivelog mode database.  'create table' is 
always nologging on noarchivelog mode.

Are you sure the create table is what's slowing you down?  What about tuning 
the select?  Also, don't forget, execution plan of select could change 
significantly if you test select by itself, and then add the create table 
later.  This is because the CTAS will optimize as ALL_ROWS, whereas the 
standalone select may be optimized w/ FIRST_ROWS.

Hope that helps,


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

Oracle 10g in a NONARCHIVE mode.
I need to create some temp tables during some process. These temp tables will 
not be updated. I am doing something like this now:

CREATE TABLE TMP_TABLE123 PCTFREE 0 parallel 3 nologging as select ... from 

Is there any other oracle parameters that I could use to make this step faster?


Other related posts: