CREATE -+-----------+-> INDEX <index-name> ------------------+
          +-> UNIQUE -+                                        |
  +------------------------------------------------------------+
  +--+-----------------------------------+-> ON <table-name> --+
     +-> STORED NAME IS <stored-name> ---+                     |
  +----------------------------- <-----------------------------+
  +> ( +> <column-name> --+
       |   +--------------+
       |   +-+-------------++-----------------------------+-+- ) -+
       |     +> ASCENDING -++> SIZE IS <n> ---------------+ |     |
       |     +> DESCENDING ++> MAPPING VALUES <l> TO <h> -+ |     |
       +---------------------- , <--------------------------+     |
  +------------------------------ <-------------------------------+
  ++----------------+-+----------------------------+-----------+
   +-> type-clause -+ +-> index-attributes-clause -+           |
  +------------------------------<-----------------------------+
  ++-----------------------+-------------------------------------->
   +-> index-store-clause -+

  type-clause =

  -> TYPE IS +> HASHED +-------------+------------------------------+>
             |         +> ORDERED ---+                              |
             |         +> SCATTERED -+                              |
             +> SORTED +-----------------------------------------+-+|
                       +> RANKED -+-----------------------------++ ||
                                  +> DUPLICATES ARE COMPRESSED -+  ||
                     +---------------------------------------------+|
                     +-+-----------------------+--------------------+
                       +> sorted-index-clause -+

  sorted-index-clause =

  --+-+-> NODE SIZE <number-bytes> ----------+-+-->
    | +-> PERCENT FILL <percentage> ---------+ |
    | +-> USAGE -+-> UPDATE -+---------------+ |
    |            +-> QUERY --+                 |
    +------------------- <---------------------+

  index-attributes-clause =

  -+-+---------------------------------------------------------+-+->
   | +-> ENABLE COMPRESSION  rlc-attr -------------------------+ |
   | +-> DISABLE COMPRESSION ----------------------------------+ |
   | +-> threshold-clause -------------------------------------+ |
   | +-> LOGGING ----------------------------------------------+ |
   | +-> NOLOGGING --------------------------------------------+ |
   | +-> COMMENT IS -+-> '<string>' -+-------------------------+ |
   | |               +------- / <----+                         | |
   | +-> PREFIX CARDINALITY COLLECTION IS -+-> ENABLED ------+-+ |
   | |                                     +-> ENABLED FULL -+ | |
   | |                                     +-> DISABLED -----+ | |
   | +-> MAINTENANCE IS -+-> DISABLED -----------------+-------+ |
   |                     +-> ENABLED -+--------------+-+         |
   |                                  +-> DEFERRED --+           |
   |                                  +-> IMMEDIATE -+           |
   +---------------------------- <-------------------------------+

  rlc-attr =

  --+--------------------------------+--------->
    +--> (MINIMUM RUN LENGTH <n> ) --+

  index-store-clause =

  STORE ----------------------+
  +---------------------------+
  ++-> IN area-spec ---------------------------------------------+>
   +-> USING -> ( -+--> <column-name> -+-> ) ----------+         |
                   +------- , <--------+               |         |
   +---------------------------------------------------+         |
   ++> IN area-spec -------------------------------------+       |
    | +--------------------------------------------------+       |
    | +-> WITH LIMIT OF -> ( -+--> <literal> -+-> ) ---+---+     |
    |                         +------ , <-----+        |   |     |
    +-----------------------<--------------------------+   |     |
  +--------------------------------------------------------+     |
  ++------------------------------------------------------------++
   +-> OTHERWISE IN area-spec ----------------------------------+

  threshold-clause =

  --+-> THRESHOLD -+-> IS -+-> ( --> <val1> --> ) ---------+->
    |              +-> OF -+                               |
    |                                                      |
    +-> THRESHOLDS -+-> ARE -+-----------+                 |
                    +-> OF  -+           |                 |
      +----------------------------------+                 |
      +-> ( --> <val1> -+---------------------------+-> ) -+
                        +-> , <val2> -+-------------+
                                      +-> , <val3> -+

  area-spec =

  --> <area-name> -+---------------------------------------------------+->
                   +-> ( -++-> threshold-clause ---------------++-> ) -+
                          |+-> LOGGING ------------------------+|
                          |+-> NOLOGGING ----------------------+|
                          |+-> PARTITION <name> ---------------+|
                          |+-> COMMENT IS -+--> 'string' ---+--+|
                          |                +------- / <-----+   |
                          +---------------- ,  -----------------+