René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Indexes in Oracle

Building indexes online

With the online index build option, it is possible to build and rebuild an index without locking the table during the operation.

Coalescing indexes

This is a less resource-intensive possibility to regain free space in an index. The index needs not be rebuilt from scratch.
Requires the coalesce index option.