create index

Add a new index (key) to a table

Syntax

create_index:
        CREATE INDEX constraint_name [USING {B_TREE | HASH} | AVL_TREE | R_TREE]
        ON [database_name.]table_name
             (column_name [ASC | DESC] [, column_name [ASC | DESC]]...)

Description

A CREATE INDEX statement is commonly available in many SQL systems but is not specified as part of the ISO/ANSI SQL Standard. RDM SQL does provide a CREATE INDEX but it is simply a different syntactic wrapper for the standard ALTER TABLE statement. The syntax shown above actually maps directly to the syntax shown below.

ALTER TABLE [database_name.]table_name
ADD CONSTRAINT constraint_name [UNIQUE] KEY [USING {B_TREE | HASH}]
     (column_name [ASC | DESC] [, column_name [ASC | DESC]]... )