v.20.10New Feature

Implement force_data_skipping_indices Setting

Implement force_data_skipping_indices setting. #15642 (Azat Khuzhin).
Introduces the force_data_skipping_indices setting to explicitly enable enforcement of data skipping indices during query execution.

Why it matters

This feature allows users to force the usage of data skipping indices, improving query performance by ensuring these indices are always applied. It helps optimize query processing by avoiding unnecessary full scans when relevant indices are available.

How to use it

To use this feature, set the force_data_skipping_indices setting to 1 or true in your session or query context. For example:

SET force_data_skipping_indices = 1;
SELECT * FROM table WHERE column = 'value';