move_* session settings

View as MarkdownEdit this pageReport an issueSet up docs MCP

These settings are available in system.settings and are autogenerated from source.

move_all_conditions_to_prewhere

Type

Bool

Default

1

Move all viable conditions from WHERE to PREWHERE

move_primary_key_columns_to_end_of_prewhere

Type

Bool

Default

1

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.