Re: sane number of the table partitions in DWH

From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Thu, 9 Apr 2009 10:34:01 -0500
Message-ID: <de807caa0904090834j1e6eaf22r82d44d8dbfdfb946_at_mail.gmail.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 09 2009 - 10:34:01 CDT

This message: [ Message body ]
Next message: Jared Still: "Re: "Practicing" Oracle performance tuning ..."
Previous message: Jeremy Schneider: "Re: "Practicing" Oracle performance tuning ..."
In reply to: Milen Kulev: "Re: sane number of the table partitions in DWH"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message