Background documentationcreate_index_statement Locate this document in the navigation structure


The CREATE INDEX (create_index_statement) SQL statement is known in SAP MaxDB, but has different syntax and semantics to Oracle (CREATE INDEX statement).

  • However, the specifications CLUSTER <cluster>, INITRANS <integer>, MAXTRANS <integer>,TABLESPACE <tablespace>, STORAGE <storage_clause>, PCTFREE <integer>, and NOSORT have no meaning for SAP MaxDB, but are accepted syntactically.

  • The index is generated in descending order in SAP MaxDB when DESC is specified.