v.21.9Improvement

Apply Aggressive IN Index Analysis for Improved Projections

Apply aggressive IN index analysis for projections so that better projection candidate can be selected. #26218 (Amos Bird).
Improves projection selection by applying aggressive IN index analysis to choose better projection candidates.

Why it matters

This feature enhances query performance by more effectively analyzing IN indexes when selecting projections, leading to the use of more optimal projections and faster query execution.

How to use it

The aggressive IN index analysis for projections is applied automatically in the query optimizer; no additional user action is required to benefit from this improvement.