Skip to content

[OPTIMIZER] Rewrite chains of ARRAY_CONTAINS to list ops (@>) #2717

@joocer

Description

@joocer

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions