Re: Partitioning best practices

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_at_gmail.com> To: <oracle-l_at_freelists.org> 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

--
http://www.freelists.org/webpage/oracle-l