Specifying Basic Wordlist Attributes

Previous

Next

You can specify attributes for the basic wordlist preference BASIC_WORDLIST such as wildcard maximum number of terms, fuzzy score, and number of fuzzy expansions for your language.

To specify or change attributes for wordlist:

1. From the Text Indexes page, select the index.

   • If this is a partitioned index, then the Partitions page appears for this index where you must select one or more partitions to edit.

2. Click Edit.

3. On the Edit Text Index page, make sure the General subpage is shown.

4. Change one or more of the following attributes:

   • Wildcard Maximum Terms. Specify the maximum number of terms in a wildcard (%) expansion. Use this parameter to keep wildcard query performance within an acceptable limit. Oracle Text returns an error when the wildcard query expansion exceeds this number.

   • Fuzzy Score. Specify a number between 0 and 80 for the default lower limit of fuzzy score. Any text with a score below this number is not returned. The default is 60.

   • Number of Fuzzy Expansions. Specify the maximum number of fuzzy expansions. Use a number between 0 and 5000. The default is 100. Setting a fuzzy expansion limits the expansion to a specified number of the best matching words.

5. Click Apply.

You can view the comparable SQL statements for this operation by clicking Show SQL. You can revert back to the previous settings by clicking Revert.