Originally posted by roadwarriorDBA
Given the recent thread on myths about rebuilding indexes please let us know if rebuilding indexes recovers significant space.
This would be a special case, where insert/delete/update gets applied to a bitmap index -- they tend to grow large very quickly. Although the problem is not so bad in more recent versions, in 8i they grow enormously. Bitmap indexes aren't really designed for such things, especialy if you have concurrent modifications.