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_at_comcast.net
>
> 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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Fri Mar 26 2004 - 18:56:58 CST
