Entering content frame

Background documentation create_index_statement Locate the document in the library structure

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

·        The specification of CLUSTER <cluster>, INITRANS <integer>, MAXTRANS <integer>, TABLESPACE <tablespace>, STORAGE <storage_clause>, PCTFREE <integer>, and NOSORT is meaningless in MaxDB, but is accepted by the syntax.

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

 

Leaving content frame