opteryx
opteryx copied to clipboard
[OPTIMIZER] Rewrite chains of ARRAY_CONTAINS to list ops (`@>`)
Rewriting chains of OR conditions into single operator is a good way to improve query performance.
When users write ARRAY_CONTAINS(x, 1) OR ARRAY_CONTAINS(x, 2) we can rewrite this to x @> (1,2) within the query optimizer. This single faster operation.