Available Options

The available CREATE INDEX options are as follows. Note that some options are only applicable to certain index types, as noted; using a option that does not apply to the given index type will result in an error:

• counts 'on'|'off'

  For Metamorph or Metamorph counter index types only. If set to "on", creates a Metamorph counter type index (useful for LIKEIN searches); if "off" (the default), a regular Metamorph or Metamorph inverted index is created.

• indexmaxsingle N

  For Metamorph, Metamorph inverted, and Metamorph counter index types only. Same as the indexmaxsingle server property (here).

• indexmem N

• indexmeter N|type

• indexspace N

• indexvalues type

  These options have the same effect as the same-named server properties set with SET.

• indexversion N

• keepnoise 'on'|'off'

• noiselist ('word','word',...)

• textsearchmode mode

• wordexpressions ('expr','expr',...)

  For Metamorph, Metamorph inverted, and Metamorph counter index types only. Same effect as the same-named server properties.

• wordpositions 'on'|'off'

  For Metamorph and Metamorph inverted index types only. If "on" (the default in version or compatibilityversion 7 and later), creates a full-inversion (Metamorph inverted) index; if "off", creates a compact (Metamorph) index.

• max_index_text N

• stringcomparemode mode

  For regular index types only. Same effect as the same-named server properties.