Oracle gurus:
I have a problem. I've a table with 5 million records, which grows at the rate
of 1 million records everyday. The is a cleanup process that deletes the oldest
1 million records. The index is on a timestamp field. My questions is, how will
my index grow. Because if I delete 1 million records, will the blocks be
released for new index rows within the index tablespace or will the be adding
new leaf nodes and not release the space. Oracle says that if there is a
performace degradation due to sparce index, the only way to correct the problem
is drop and recreate the index. This would not be feasible for my situation
because we operate as 24 by 7.
Could someone shed some information on this regard.
Thank you in advance,
Chandra
chandra_at_mink.mt.att.com