Index only on newest partition?

  • From: "Bjørn D. Jensen" <bjorn.d.jensen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 28 Jan 2008 20:43:22 +0100

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:

  1. Home
  2. oracle-l
  3. Archive
  4. 01-2008