O'Reilly logo
  • Lucas Reis thinks this is interesting:

As applications age, you invariably have to perform some maintenance activities on existing indexes. You may need to rename an index to conform to newly implemented standards, or you may need to rebuild a large index to move it to a different tablespace that better suits the index's storage requirements.

From

Cover of Pro Oracle Database 11g Administration

Note

Maintaining indexes