anyone ever use sub-partitioning?
- From: <ryan.gaffuri@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 30 Apr 2004 10:27:16 -0400
We have a table which is about 8GB with about 8 billion records. We add deltas
to the file daily(inserts,updates,deletes).
We are considering paritioning this table so we can use parallel DML. We are
considering partitioning on the primary key to about 10-20 partitions.
Has anyone used hash sub-partitioning? What are your experiences with that? I'd
like to have granularity smaller than 400-800 MB per partition.
----------------------------------------------------------------
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:
