Home » RDBMS Server » Performance Tuning » Creating Partitioned table faster than Non-partitioned
Creating Partitioned table faster than Non-partitioned [message #188412] Fri, 18 August 2006 07:52 Go to next message
Messages: 194
Registered: January 2006
Senior Member
I am using CTAS to create a table of 50M records. I noticed that when I include the partitions while creating:

partition by range (TRXN_DATE)

. . .
as SELECT . . .

it is faster than creating it without the partitions:

as SELECT . . .

I don't quite understand why.. can anyone explain??
Re: Creating Partitioned table faster than Non-partitioned [message #188523 is a reply to message #188412] Sat, 19 August 2006 00:44 Go to previous message
Messages: 3727
Registered: October 2005
Location: Melbourne, Australia
Senior Member
You'd have to show us the SQL and the EXPLAIN PLAN of both. It is likely that the faster one is using parallelism of some kind, because they have to do the same amount of I/O.

If the source table is also partitioned, then Oracle could probably parallelise that very efficiently.

Ross Leishman
Previous Topic: From staging tables to datamart table -- how?
Next Topic: Oracle 9i redo logging performance poor in relation to DB2 on Solaris. Please help.
Goto Forum:

Current Time: Mon Aug 21 12:55:56 CDT 2017

Total time taken to generate the page: 0.05238 seconds