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.