v.20.10Improvement

Added optimize setting to EXPLAIN PLAN query for automatic query plan optimizations

Official CH changelog text
Added optimize setting to EXPLAIN PLAN query. If enabled, query plan level optimisations are applied. Enabled by default. #15201 (Nikolai Kochetov).
Added an optimize setting to the EXPLAIN PLAN query that applies query plan level optimizations.

Why it matters

This feature enables users to see the execution plan of a query with optimizations applied, providing a more accurate and realistic representation of how the query will be executed, which helps in better understanding and tuning query performance.

How to use it

The optimize setting is enabled by default when running EXPLAIN PLAN. Users can specify this setting explicitly in the query settings if desired to enable or disable query plan optimizations.

Related resources

PreviousNext