optimize_move_to_prewhere_* session settings

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

optimize_move_to_prewhere

Enables or disables automatic PREWHERE optimization in SELECT queries. Works only for *MergeTree tables. Possible values:

0 — Automatic PREWHERE optimization is disabled.
1 — Automatic PREWHERE optimization is enabled.

optimize_move_to_prewhere_if_final

Enables or disables automatic PREWHERE optimization in SELECT queries with FINAL modifier. Only conditions that depend on the sorting key alone and are deterministic within the query are moved, so the result of FINAL is not affected. Works only for *MergeTree tables. Possible values:

0 — Automatic PREWHERE optimization in SELECT queries with FINAL modifier is disabled.
1 — Automatic PREWHERE optimization in SELECT queries with FINAL modifier is enabled.

See Also

optimize_move_to_prewhere setting

SQL Reference

Data Types

Engines

Functions

Formats

Settings

System Tables

Data Lakes

optimize_move_to_prewhere_* session settings