v.25.11Performance Improvement
Allow using projections as secondary index
Allow using projections (that use SELECT of _part_offset and a different ORDER BY) as a secondary index. When enabled, certain query predicates can be used to read from projection parts and generate bitmaps to filter rows efficiently during the PREWHERE stage. This is the third step to implement projection index, following #80343. #81021 (Amos Bird).