Index only on newest partition?

From: Bjørn D. Jensen <>
Date: Mon, 28 Jan 2008 20:43:22 +0100
Message-ID: <>

If you have an huge table that is partitioned; is it possible to only have an index on the newest partition?

think about the situation where users typical are intereted in the newest part,
but you can live with slower performance for history data.

Bjorn D. Jensen

Received on Mon Jan 28 2008 - 13:43:22 CST

Original text of this message