CTXCAT Index Parameters

The following default parameters are used when you create a CTXCAT index with CREATE INDEX and do not specify any parameters in the parameter string. The CTXCAT index supports only the index set, lexer, storage, stoplist, and wordlist parameters. Each default parameter names a system-defined preference.

Table 48 Default CTXCAT Index Parameters

Parameter Used When Default Value
DEFAULT_CTXCAT_INDEX_SET No index set specified in parameter clause of CREATE INDEX. n/a
DEFAULT_CTXCAT_STORAGE No storage preference specified in parameter clause of CREATE INDEX. CTXSYS.DEFAULT_STORAGE
DEFAULT_CTXCAT_LEXER No lexer preference specified in parameter clause of CREATE INDEX. CTXSYS.DERAULT_LEXER
DEFAULT_CTXCAT_STOPLIST No stoplist specified in parameter clause of CREATE INDEX. CTXSYS.DEFAULT_STOPLIST
DEFAULT_CTXCAT_WORDLIST No wordlist preference specified in parameter clause of CREATE INDEX.

Note that while you can specify a wordlist preference for CTXCAT indexes, most of the attributes do not apply, because the catsearch query language does not support wildcarding, fuzzy, and stemming. The only attribute that is useful is PREFIX_INDEX for Japanese data.
CTXSYS.DEFAULT_WORDLIST

See Also: “System-Defined Preferences”