Re: How can I decide which partition type can I chose
Posted by:
Rick James
Date: September 12, 2010 03:11PM
"If I had to partition the table, what would be the best option." -- Do not partition a table without a goal in mind.
Two common goals:
* time series, where you want to delete old data
* performance -- for this we need to see all the relevant SELECTs, plus the table structure (pre-partitioned is ok).
There are many ways you _could_ partition the table; most do not provide any benefit.
Subject
Views
Written By
Posted
4504
September 08, 2010 07:00AM
1558
September 09, 2010 02:28PM
Re: How can I decide which partition type can I chose
1807
September 12, 2010 03:11PM
1902
September 12, 2010 10:10PM
1756
September 13, 2010 11:03AM
1647
September 14, 2010 06:27AM
2284
September 14, 2010 07:44AM
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.