|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
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.
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.