Re: Partitioning best practices
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <anuragdba@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 1 Sep 2006 20:01:22 +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.
Regards
Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
----- 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,
Anurag
--------------------------------------------------------------------------------
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
