v.20.10New Feature
Implement force_data_skipping_indices Setting
Implement force_data_skipping_indices setting. #15642 (Azat Khuzhin).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 theforce_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';