Show TOC

create_index_statementLocate this document in the navigation structure

Use

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.

More Information