December 2002
Intermediate to advanced
928 pages
85h 29m
English
CREATE/ALTER/DROP INDEX
CREATE Syntax:
CREATE [OR REPLACE] [UNIQUE | BITMAP] INDEX [schema.]indexnameON { CLUSTER [schema.]clusterIndex_Attributes_Clause| [schema.]table_name[alias] ({column|col_expr} [ASC | DESC] [,{column|col_expr} [ASC | DESC] ...]) [{ { {GLOBAL PARTITION BY RANGE (column_list) (PARTITION partition_name VALUES LESS THAN (value[, value...]) [Physical_Attributes_Clause] [TABLESPACE tablespace_name] [LOGGING | NOLOGGING] | LOCAL (PARTITIONpartition_name[Physical_Attributes_Clause] [TABLESPACEtablespace_name] [LOGGING | NOLOGGING] [,PARTITIONpartition_name[Physical_Attributes_Clause] [TABLESPACEtablespace_name] [LOGGING | NOLOGGING] ...]) | LOCAL {STORE IN ({tablespace_name[,tablespace_name...]|DEFAULT}) | (PARTITION [partition_name] [TABLESPACEtablespace_name] [,PARTITION [partition_name] [TABLESPACEtablespace_name] ...]) } | LOCAL STORE IN ({tablespace_name[,tablespace_name...] | DEFAULT}) (PARTITION [partition_name] [Index_Attributes_Clause] { STORE IN {tablespace_name[,tablespace_name...] | DEFAULT} | (SUBPARTITIONsubpartition_name[TABLESPACEtablespace_name] [,SUBPARTITIONsubpartition_name[TABLESPACEtablespace_name] ...]) } } | Index_Attributes_Clause } | INDEXTYPE IS indextype [PARALLEL | NOPARALLEL] [PARAMETERS('parmstring')] } | [schema.]table_name([schema.]table_name column [{ASC | DESC}] [,[schema.]table_name column [{ASC | DESC}]...]) FROM [schema.]table_name[,[schema.]table_name...] WHERE condition { LOCAL (PARTITION ...