Implement In Order Aggregation for Fully Materialized Projections

Why it matters

This feature optimizes aggregation performance for fully materialized projections by leveraging the natural order of data, reducing computation time and resource usage during query execution.

How to use it

Enable the optimization by setting the parameter optimize_aggregation_in_order to 1 (true) in the server or session settings. Queries involving fully materialized projections will then take advantage of the in order aggregation optimization automatically.