CREATE/ALTER/DROP INDEX |
CREATE [UNIQUE | BITMAP] INDEX [schema.]indexname ON {[schema.]TABLE [alias] ({column|col_expr] [ASC | DESC] [,{column|col_expr} [ASC | DESC] ...]) | CLUSTER [schema.]cluster } [{[GLOBAL PARTITION BY RANGE (column_list) (Global_Partition_Clause[,Global_Partition_Clause...]) [TABLESPACE {tablespace | DEFAULT}] [Physical_Attributes_Clause] [STORAGE Storage_Clause] [NOSORT | REVERSE] [UNRECOVERABLE | LOGGING | NOLOGGING] [ONLINE] [COMPUTE STATISTICS] [COMPRESS integer | NOCOMPRESS] [PARALLEL integer | NOPARALLEL] ] | [LOCAL (PARTITION partition [Physical_Attributes_Clause] [TABLESPACE tablespace] [LOGGING | NOLOGGING] [,PARTITION partition [Physical_Attributes_Clause] [TABLESPACE tablespace] [LOGGING | NOLOGGING] ...]) [TABLESPACE {tablespace | DEFAULT} [Physical_Attributes_Clause] [STORAGE Storage_Clause] [NOSORT | REVERSE] [UNRECOVERABLE | LOGGING | NOLOGGING] [ONLINE] [COMPUTE STATISTICS] [COMPRESS integer | NOCOMPRESS] [PARALLEL integer | NOPARALLEL] ] | [LOCAL {STORE IN {tablespace[,tablespace...]|DEFAULT) | (PARTITION [partition] [TABLESPACE tablespace] [,PARTITION [partition] [TABLESPACE tablespace] ...]) } [TABLESPACE {tablespace | DEFAULT} [Physical_Attributes_Clause] [STORAGE Storage_Clause] [NOSORT | REVERSE] [UNRECOVERABLE | LOGGING | NOLOGGING] [ONLINE] [COMPUTE STATISTICS] [COMPRESS integer | NOCOMPRESS] [NOSORT | REVERSE] [PARALLEL integer | NOPARALLEL] ] | [LOCAL {STORE IN (tablespace[,tablespace ...] | DEFAULT) | (PARTITION [partition |
Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.