Reasonable number of partitions?
Hello,
I'm trying to get a measurement for a reasonable number of partitions for a large table.
For example, I have a table with 100,000,000 rows. Is it reasonable to partition it by HASH with 100 partitions? 1000 partitions?
Also, is it reasonable to partition by HASH with 100 partitions, then sub partition by HASH with 100 sub partitions?
Last, is there a means to calculate an "optimal" number of partitions? What are the costs and penalties of using many partitions?
Thanks in advance,
Shlomi
Subject
Views
Written By
Posted
Reasonable number of partitions?
7179
March 08, 2007 10:09AM
10388
March 09, 2007 12:39AM
4570
March 11, 2007 08:30AM
4910
March 13, 2007 09:53PM
5240
March 14, 2007 12:34PM
3870
September 20, 2007 08:36PM
3645
September 12, 2007 11:26AM
3743
September 13, 2007 09:47AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.