RE: hash partitioning
- From: "Jacques Kilchoer" <Jacques.Kilchoer@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 26 Mar 2004 16:52:59 -0800
Why are you partitioning the table?
To break up the size of the table so that each partition has a size less than X
GB?
To make sure that each portion of a local partitioned index has a lower blevel?
To make maintenance operations more manageable because you can do things (like
moving to a different tablespace) a single partition at a time?
To be able to use parallelism and spread the work across several disks on bulk
loads?
Because you've paid for the feature and you figure that it would be a shame not
to use it?
> -----Original Message-----
> thump604@xxxxxxxxxxx
>
> How does one determine the optimal number of partitions when
> setting up a hash partitioned table?
> -David
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
