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).
Added the ability to ignore specific skip indices during query execution by using the ignore_data_skipping_indices setting.

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 the ignore_data_skipping_indices setting in their query or session configuration, listing the skip indices they want to ignore during query processing.