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
    • Resolution: Fixed
    • Major
    • 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

          finishs with

          Improvement - An improvement or enhancement to an existing feature or task. MB-54771 CBO enhancements and fixes after calibration tests

          • Major - Major loss of function.
          • Closed
          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            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