Create Index

An index stores the values of one or more fields of every document in a schema, so that queries can find documents by those values without reading the whole schema. A unique key (UNIQUEKEY) is an index that also rejects documents whose values already exist in the schema.

CREATE INDEX IndexName (Field1 [, Field2 ...]) ON Schema
CREATE UNIQUEKEY IndexName (Field1 [, Field2 ...]) ON Schema

Creating an index indexes the documents already in the schema. From then on, inserts, updates and deletes keep it up to date in the same transaction. Requires the Manage permission on the schema.

• A condition that compares an indexed field to a value with = is answered from the index.
• A composite index is used when its leading fields are compared with =. When every field of a unique key is compared, the lookup is a single key read.
• When several conditions can each use an index, the results of the indexes are intersected.
• The management UI's Explain Plan button (and the client API's ExplainPlan) shows which indexes a query will use, and suggests CREATE INDEX statements for conditions that would otherwise read every document.

Creates an index on Text.

CREATE INDEX IX_Word_Text
(
    Text
) ON WordList:Word

Creates a composite index.

CREATE INDEX IX_Word_LanguageId_Text
(
    LanguageId,
    Text
) ON WordList:Word

Creates a unique key on Id.

CREATE UNIQUEKEY UK_Language_Id
(
    Id
) ON WordList:Language

• Drop Index
• Rebuild Index
• Analyze Index