Three database options have changed as follows:
DEFAULT_HAVING_SELECTIVITY is now DEFAULT_HAVING_SELECTIVITY_PPM
DEFAULT_LIKE_MATCH_SELECTIVITY is now DEFAULT_LIKE_MATCH_SELECTIVITY_PPM
DEFAULT_LIKE_RANGE_SELECTIVITY is now DEFAULT_LIKE_RANGE_SELECTIVITY_PPM
The meanings of these parameters is the same. Instead of “percent” they are now “parts-per-million” parameters, where 15.0 1% = 10,000. In IQ 12.7, 1% = a parameter setting of “1”. The default values for DEFAULT_LIKE_MATCH_SELECTIVITY_PPM and DEFAULT_LIKE_RANGE_SELECTIVITY_PPM parameters have changed accordingly. They were “15” and are now “150000” (150,000, or 15%). The DEFAULT_HAVING_SELECTIVITY_PPM parameter still has a default of zero (meaning to let the optimizer choose).
