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

​
move_all_conditions_to_prewhere

Move all viable conditions from WHERE to PREWHERE

​
move_primary_key_columns_to_end_of_prewhere

Move PREWHERE conditions containing primary key columns to the end of AND chain. It is likely that these conditions are taken into account during primary key analysis and thus will not contribute a lot to PREWHERE filtering.
Last modified on July 22, 2026