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

Create Index in Oracle

create index is one of the few statements that can make use of the nologging option.
create index requires a temporary segment if the statement cannot be completed in memory.

Function Based Indexes

Function based indexes require query_rewrite_enabled be set to true and query_rewrite_integrity be set to trusted.
Thanks to Clark Lu who reported an error on this page.