optimize_use_* session settings

View as MarkdownEdit this pageReport an issueSet up docs MCP

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

optimize_use_implicit_projections

Type

Bool

Default

1

Automatically choose implicit projections to perform SELECT query

optimize_use_projection_filtering

Type

Bool

Default

1

Version history

Version	Default value	Comment
25.6	1	New setting

Enables using projections to filter part ranges even when projections are not selected to perform SELECT query.

optimize_use_projections

Aliases: allow_experimental_projection_optimization

Type

Bool

Default

1

Enables or disables projection optimization when processing SELECT queries.

Possible values:

0 — Projection optimization disabled.
1 — Projection optimization enabled.