RE: make create table run faster?

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Tue, 28 Apr 2009 12:04:51 -0400
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F1681E71A_at_AAPQMAILBX02V.proque.st>

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,

-Mark

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Guang Mei Sent: Tuesday, April 28, 2009 11:56 AM
To: oracle-l_at_freelists.org
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 <some_base_tables>

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

Guang

--

http://www.freelists.org/webpage/oracle-l Received on Tue Apr 28 2009 - 11:04:51 CDT