Question on hash partitioning
I have a table with 59786484 records. The table has the potential to grow 10 times more.
I am planning on partitioning this table using hash partitioning on the most queried column.
Is there a recommendation upon how many partitions are optimal for given number of records?
What would you take into consideration when deciding upon the number of partitions?
Can we add more partition at later point If need?
We will be going to windows 64 bit oracle 10g from windows 32bit oracle 9i
Thanks
Jesi