Optimize fuzzy evaluation

Use the full text search (FTS) to optimize the analyses of fuzzy conditions built with cross objects or fields.

FTS can be enabled or disabled by configuring the OptimizedFuzzyEvaluation setting in the BizRightssetting table of the IRC database. You can use this query to change the setting.

 UPDATE BizRightsSettings SET SettingValue = '1' WHERE SettingName = 'OptimizedFuzzyEvaluation'

The values that can be set are:

  • 0 (Zero): Disable optimized evaluation
  • 1: Enabled optimized evaluation

    Default is 1 indicating optimization is enabled and FTS is used for evaluation.

Note: When FTS is enabled, the analysis performance increases. But depending on the data being analyzed few fuzzy matches may be skipped.