Index only on newest partition?
Date: Mon, 28 Jan 2008 20:43:22 +0100
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
but you can live with slower performance for history data.
Bjorn D. Jensen