Syntax

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram>>-CREATE--+----------------------------+--INDEX--index-name---->
           +-UNIQUE--+----------------+-+
           |         '-WHERE NOT NULL-' |
           '-ENCODED VECTOR-------------'
 
                      .-,---------------------.
                      V              .-ASC--. |
>--ON--table-name--(----column-name--+------+-+--)-------------->
                                     '-DESC-'
 
>--index-options-----------------------------------------------><
 
index-options:
 
|--+-------------------------------------+---------------------->
   |                .-DISTINCT-.         |
   '-WITH--integer--+----------+--VALUES-'
 
                        .-PAGESIZE--64------. (1)
>--+-----------------+--+-------------------+-------------------|
   +-NOT PARTITIONED-+  '-PAGESIZE--+-8---+-'
   '-PARTITIONED-----'              +-16--+
                                    +-32--+
                                    +-64--+
                                    +-128-+
                                    '-512-'
 
Notes:
  1. The index-options may be specified in any order.