Re: Index only on newest partition?

From: jaromir nemec <>
Date: Tue, 29 Jan 2008 22:46:35 +0100
Message-ID: <254201c862c0$6ba2e6a0$3e02a8c0@ADLA>


> is it possible to only have an index on the newest partition?

a do-it-yourself solution is simple to split the table in two partitioned tables (active and history) with a periodic process moving the outdated parts from active into the history table. This solution allows not only different access to the two types of data but also different structures (e.g. in case the are limited requirements on the history data structure). The access can be transparently defined in a union all view, but of course a safer way is - as Connor mentioned - a "specially crafted" SQL. You may say that this was an ideal solution in the 7.2 release - and you'll be generally speaking not to much wrong.



Received on Tue Jan 29 2008 - 15:46:35 CST

Original text of this message