v.21.11Improvements
Added use_skip_indexes Setting
Added setting use_skip_indexes. #29405 (Maksim Kita).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 settinguse_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;