Environment Catalog

Index Statement

INDEX index_name
TYPE index_type_spec
AS column_spec [, column_spec...]
[PHYSICAL "native_index"]

INDEX index_name

[[environment_name.]database_name.]index_name

index_name represents a non-ambiguous index or view.

index_name MUST BEGIN WITH A LETTER, A-Z (case insensitive) and may contain up to 32 characters including letters, numbers and allowed special characters.

If index_name contains any reserved words or allowed special characters, it must be enclosed in single or double quotes.

If the underlying database contains native indexes for any of the tables defined in the Omnidex Environment Catalog, you must declare these indexes in this section. If not declared, data retrievals will either be performed by serial read or return incorrect data.

TYPE index_type_spec

Required when declaring an INDEX index and can declare any one of these values:

• INVERTED
• HASHED
• SORTED
• LINKED LIST

AS column_spec [, column_spec...]

Required when declaring an INDEX index. This string, up to 32 characters long, uniquely identifies the column defined within the Environment to which the native index corresponds.

PHYSICAL "native_index"

Optional. This is a quoted string of up to 255 characters which references the underlying database's native name for the index.

Top