Re: Index only on newest partition?

Hi,

> 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.

Regards,

Jaromir

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