Re: sane number of the table partitions in DWH
Date: Thu, 9 Apr 2009 10:34:01 -0500
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 WilliamsReceived on Thu Apr 09 2009 - 10:34:01 CDT