Re: Get partition name for specific date
Hi Rick,
thanks for the good idea.
As I am not experienced with partitioning, I am thankful for your opinion about the number of partitions. I chose 92 because that's the max number of days we keep the historical data. The data set is quite huge for my commodity hardware (10M rows per day). And I have to import them quite fast. Fortunately, most of my queries only require data from one day, a few require data from two dates. So I thought it would be a good way to help keeping the whole index or even data set in memory by using this granular partitioning. It seems to work good for me up until now. What are your worries about having many partitions?
Kind regards
Jan
Subject
Views
Written By
Posted
2968
October 08, 2012 12:48PM
1649
October 09, 2012 09:21AM
Re: Get partition name for specific date
1522
October 10, 2012 03:18AM
1634
October 11, 2012 07:12PM
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.