Port optimization of Set expressions from Classic in SBE

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Fixed
    • Priority: Major - P3
    • 8.2.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Execution
    • Fully Compatible
    • QE 2025-04-28
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      The Classic engine optimizes the setIsSubset expression by converting a constant array argument into an unordered set, so that at runtime it is already available for being probed quickly. The SBE version will repeatedly convert the array into a set at each iteration

            Assignee:
            Alberto Massari
            Reporter:
            Alberto Massari
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: