Index only on newest partition?
From: Bjørn D. Jensen <bjorn.d.jensen_at_gmail.com>
Date: Mon, 28 Jan 2008 20:43:22 +0100
Message-ID: <ad965e0f0801281143o23c3fbf1sfae4cbb9d9b17781@mail.gmail.com>
Date: Mon, 28 Jan 2008 20:43:22 +0100
Message-ID: <ad965e0f0801281143o23c3fbf1sfae4cbb9d9b17781@mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 28 2008 - 13:43:22 CST