Overhead of table with empty partitions
From: John Thompson <jhthomp_at_gmail.com>
Date: Wed, 28 May 2008 10:57:53 -0500
Message-ID: <11d63ad10805280857u40611494x7f70b794cdad9a13@mail.gmail.com>
Date: Wed, 28 May 2008 10:57:53 -0500
Message-ID: <11d63ad10805280857u40611494x7f70b794cdad9a13@mail.gmail.com>
Say I've got a table that's partitioned by day and has 30 days worth of
partitions. Every 30 days I'll create another 30 days worth of partitions
and drop the previous 30 days worth. Stats are running everyday so the
thinking is that having 29 or so days worth of empty partitoins will not
cause any SQL performance issues. Testing has shown this to be the case,
but wanted to see if there's any insight on having many empty partitions.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 28 2008 - 10:57:53 CDT