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.
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.
|