Fuzzy_Match: Fuzzy matching routines to be used for the column. Fuzzy matching is
currently supported for English, Japanese, and, to a lesser extent, the Western
European languages.
Values: GENERIC (default), JAPANESE_VGRAM, KOREAN, CHINESE_VGRAM, ENGLISH,
DUTCH, FRENCH, GERMAN, ITALIAN, SPANISH, or OCR
Note: The fuzzy_match attribute values for Chinese and Korean are dummy attribute values that prevent the English and Japanese fuzzy matching routines from being used on Chinese and Korean text.
Fuzzy_Numresults: Maximum number of fuzzy expansions.
Values: number between 0 and 5000
Fuzzy_Score: Default lower limit of fuzzy score; scores below this number are not
produced.
Values: number between 0 and 80
Stemmer: The stemmer used for word stemming in text queries.
Values: blank (no stemming), ENGLISH (default: English inflectional),
DERIVATIONAL (English derivational), DUTCH, FRENCH, GERMAN, ITALIAN, or SPANISH
Substring_Index: If YES, causes a pattern table to be created to expedite wildcard searching.
Because wildcard searches are processed by expanding the pattern using a LIKE,
they force a full-table scan of the main index table. This type of query,
sometimes called a left-truncated search, takes a long time. A pattern table (with
parameters specified by the P_Table_Clause) stores rotations of all unique words in the main index table. Using the
pattern table instead of the main index table allows left-truncated searches to be
processed more quickly. However, the query-time savings come at the cost of
significantly increased index time and space. Therefore, this option should be used
only when left-truncated wildcard searches are frequent and need to be fast.
Values: YES or NO (default)
Wildcard_Maxterms: Maximum number of words to extend the pattern for wildcard searches. The
default is 5000. Wildcard searching is done by expanding the pattern against the
main index table using LIKE, and searching on all the resulting words. Larger Wildcard_Maxterms values provide more wildcarding flexibility but use up memory more quickly.
If wildcard patterns match more words than Wildcard_Maxterms, a "query too complex" error occurs.
Values: number (default: 5000)
Buttons (Apply, Revert, Show SQL/Hide SQL)
See also: Main topics (outline)