The WORD_SUPPORT parameter

The WORD_SUPPORT index parameter allows you to specify the type of word search the index supports.

Specify EXACT if you plan to perform exact word searches only. Specify PATTERN if you want the index to support both exact and pattern searches. The default for this parameter is EXACT.

For an explanation of what exact and pattern searches are, see Concepts.