O'Reilly logo

Oracle SQL: the Essential Reference by David C. Kreines

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required