Re: sane number of the table partitions in DWH
- From: Dennis Williams <oracledba.williams@xxxxxxxxx>
- To: makulev@xxxxxxx
- Date: Thu, 9 Apr 2009 10:34:01 -0500
Milen,
Sorry for the late reply. Been busy.
My guess is that the developers want small partitions so the table scan is
small and fast. Been there done that. One idea is to realize that most of
the queries will attack the most recent data. So you may want to use small
partitions for the most recent data and then move them to larger partitions
as they aren't scanned so often.
Also you may be able to come to a compromise. Maybe the developers want
daily partitions, but weekly partitions wouldn't hurt performance too bad.
Dennis Williams
Other related posts:
