Index only on newest partition?

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

Thanks
Bjorn D. Jensen

Other related posts: