Product Documentation

Appearance

All platforms

enable_inlist_const_expressions_simplify (boolean) ​

  • Default value (as of this release): off

When enabled, the planner extends existing IN and NOT IN rewrites to also recognize constant expressions—such as UPPER('de') or TRIM(' FR ')—in addition to plain constants and parameters.

This allows these filters, as well as equivalent chained OR conditions, to be rewritten into more efficient SEMI or ANTI joins, improving performance for queries like:

sql
SELECT * FROM customers WHERE country IN (UPPER('de'), LOWER('FR'), 'US');