Set up docs MCPThese settings are available in system.settings and are autogenerated from the ClickHouse snapshot.
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.