Originally posted by DaPi:

- REBUILDing indexes is almost never required. (Search this forum or "Ask Tom" for opinions.) So you probably don't want to do that either.
Well.......that's debatable, especially in the older versions: Oracle 7/8 , where coalesce is not an option and in situations where we can't change the code.
I have seen dramatic performance gains on rebuilding indexes in several Oracle 8 databases.