Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-56577

[CX] Extend CBO to include outer joins in query planning

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Critical
    • Morpheus
    • Morpheus
    • analytics
    • 0
    • Analytics CBO Sprint 20, Analytics CBO Sprint 21, Analytics Sprint 24

    Description

      Outer joins are not considered during join enumeration - they need to be included.

      We need to explore outer join rewrite rules and the order of their application.

      The outer join simplification rules should be invoked before the join enumeration rules in order to get a more optimal tree with fewer outer joins.

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            murali.krishna Murali Krishna
            till Till Westmann
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty