When to use partitions (Oracle8)
From: DanHW <danhw_at_aol.com>
Date: 04 Jul 1999 15:22:36 GMT
Message-ID: <19990704112236.08673.00004593_at_ng-fh1.aol.com>
I have a datawarehouse table that grows at the rate of about 50-80M (800,000 -1,000,000 rows) per day.Using Oracle 8, I can use partitions to faciltate the loading and archiving of the data, and this should also help the perfomance of queries. My question is does any one have any experience on using them? ie, Should I put each day in its own partition (obvious have lots of 'small' partitions), or maybe 1 partition per week, or 1 per month (less partitions, but bigger)
Date: 04 Jul 1999 15:22:36 GMT
Message-ID: <19990704112236.08673.00004593_at_ng-fh1.aol.com>
I have a datawarehouse table that grows at the rate of about 50-80M (800,000 -1,000,000 rows) per day.Using Oracle 8, I can use partitions to faciltate the loading and archiving of the data, and this should also help the perfomance of queries. My question is does any one have any experience on using them? ie, Should I put each day in its own partition (obvious have lots of 'small' partitions), or maybe 1 partition per week, or 1 per month (less partitions, but bigger)
The client does not want to consolidate data to weekly/monthly/annual rollups, but when they see how much data this is they may reconsider.
I expect *most* activity will be limited to using data in the last month or so; most will not be looking data for only one day.
Any thoughts?
Thanks for your help
Dan Hekimian-Williams Received on Sun Jul 04 1999 - 17:22:36 CEST