Re: Partitioning best practices

  • From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 1 Sep 2006 20:14:40 +0100

First decide a) why you want to partition b) how any particular form of partitioning gets you a benefit.

e.g. If it's for ease of loading and maintenance, then
a typical strategy will be range partitioning with local
indexes so that you can partition by time and use
partition exchange and drop.

If it's for performance, then you partition according to
the most critical queries, introduce global indexes where
necessary, worry about options for (full and partial)
partition-wise joins; and take the hit on loading, exchanging
and dropping partitions.

In both cases you try to work out how a suitable degree
of parallelism will benefit you.


Jonathan Lewis

The Co-operative Oracle Users' FAQ

Cost Based Oracle: Fundamentals

----- Original Message ----- From: "Anurag Verma" <anuragdba@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Friday, September 01, 2006 7:50 PM
Subject: Partitioning best practices

Hi All,

can any of you suggest best practices for partitioning in a Datawarehousing environment.

for example, how to implement partitioning on fact tables>

My table has 150 million rows in it.

Any useful links are always welcome.

Thanks in advance,

Best Rgds,


No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.11.7/435 - Release Date: 31/08/2006


Other related posts: