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