SonicBase. In-memory embedded or distributed streaming sql database

SQL Create Index Statement

Creates an index for the specified table


CREATE [UNIQUE] INDEX index_name on table_name(column [,column...])
index_name:  name of the index to create
table_name:  name of the table to create the index in
column:   name of the column to include in the index
UNIQUE  If included, the index contents must include unique keys


create index age on persons(age)