v.23.5New Feature
Ability to Ignore Skip Index with ignore_data_skipping_indices
Ability to ignore a skip index by specifying ignore_data_skipping_indices. #50329 (Boris Kuschel).Why it matters
This feature allows users to bypass certain skip indices that may not be beneficial or could negatively impact query performance. It provides greater control over query optimization and index usage, enabling more flexible and efficient query tuning.How to use it
Users can enable this feature by specifying theignore_data_skipping_indices setting in their query or session configuration, listing the skip indices they want to ignore during query processing.