This PR aims to optimize IN expressions with static clauses. The example benchmark a in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10) included is rather small but illustrates the point, especially since allocations grow in proportion to number of entries involved. In production we have expressions against 40k+ IN entries, which massively benefits from this optimization.
This PR aims to optimize
IN
expressions with static clauses. The example benchmarka in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10)
included is rather small but illustrates the point, especially since allocations grow in proportion to number of entries involved. In production we have expressions against 40k+IN
entries, which massively benefits from this optimization.