v.21.11Improvements

Added use_skip_indexes Setting

Added setting use_skip_indexes. #29405 (Maksim Kita).
Added a new setting use_skip_indexes to control the usage of skip indexes during query execution.

Why it matters

This setting allows users to enable or disable the utilization of skip indexes, which can improve query performance by skipping irrelevant data parts. It provides finer control over query optimization and execution behavior.

How to use it

Users can enable or disable skip indexes by setting use_skip_indexes to 1 (enable) or 0 (disable) in their session or query settings, for example:

SET use_skip_indexes = 1;
SELECT * FROM table WHERE condition;