This section describes the DDL commands pertaining to indexes.
Define an new index for a given object type or link.
CREATE INDEX ON ( index-expr )
[ "{" subcommand; [...] "}" ] ;
where subcommand is one of
CREATE ANNOTATION annotation-name := value
Most sub-commands and options of this command are identical to the
SDL index declaration. There’s
only one subcommand that is allowed in the CREATE INDEX
block:
Set object type annotation-name to value.
See CREATE ANNOTATION
for details.
Alter the definition of an index.
ALTER INDEX ON ( index-expr )
[ "{" subcommand; [...] "}" ] ;
where subcommand is one of
CREATE ANNOTATION annotation-name := value
ALTER ANNOTATION annotation-name := value
DROP ANNOTATION annotation-name
ALTER INDEX
is used to change the annotations of an index. The index-expr is used to
identify the index to be altered.
The specific expression for which the index is made. Note also
that <index-expr>
itself has to be parenthesized.
The following subcommands are allowed in the ALTER INDEX
block:
Set index annotation-name to
value.
See CREATE ANNOTATION
for details.
Alter index annotation-name.
See ALTER ANNOTATION
for details.
Remove constraint annotation-name.
See DROP ANNOTATION
for details.