Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None
    • Target Version/s:

      Description

      For example, if there is only WHEN NOT MATCHED clause, the base generating expression can be an INNER JOIN

      Generally, we should make sure the optimizer is able to work with the plan for Merge statement

      Various WHEN clauses can have "extra" predicates. In some cases they may be pushable.

      The "source" can be an arbitrary expression - in particular it may include joins which together with the join introduced by Merge itself may need to be reordered.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                ekoifman Eugene Koifman
                Reporter:
                ekoifman Eugene Koifman
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: