Indexing and DML

To index, you must create a dummy column to specify in the CREATE INDEX statement. This column’s contents are not made part of the virtual document, unless its name is specified in the columns attribute.

The index is synchronized only when the dummy column is updated. You can create triggers to propagate changes if needed.