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

[CX] Modify the NL Index join costing formula based on the calibration results.

    XMLWordPrintable

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • Morpheus
    • Morpheus
    • analytics
    • Untriaged
    • 0
    • Unknown
    • Analytics CBO Sprint 8, Analytics CBO Sprint 9

    Description

      Consider R.a = S.a and S.b < 25.

      R is the outer side and S is the inner side.

      The nested loop index join does not apply the S.b < 25 predicate. The number of rows produced is based on the join predicate only. This observation is reflected in the new formula.

      Attachments

        Issue Links

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

          Activity

            There are no comments yet on this issue.

            People

              murali.krishna Murali Krishna
              murali.krishna Murali Krishna
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 32h
                  32h
                  Remaining:
                  Remaining Estimate - 32h
                  32h
                  Logged:
                  Time Spent - Not Specified
                  Not Specified

                  Gerrit Reviews

                    There are no open Gerrit changes

                    PagerDuty