Skip to main content
These settings are available in system.settings and are autogenerated from source.

optimize_redundant_comparisons

Detect conflicting and redundant comparison conditions on the same expression within AND chains. For example, a < 1 AND a > 5 would be rewritten to false. A contradiction between two equals on the same expression (for example, a = 1 AND a = 2) is detected independently of this setting.

optimize_redundant_functions_in_order_by

Remove functions from ORDER BY if its argument is also in ORDER BY
Last modified on September 25, 2026