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

CBO not choosing indexnl join when there are multiple join predicates

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • Goldfish GA
    • 7.2.4
    • analytics
    • Untriaged
    • 0
    • Unknown
    • Analytics Sprint 38, Analytics Sprint 39, Analytics Sprint 40, Analytics Sprint 41, Analytics Sprint 42

    Description

      CBO does not pick an indexnl join when there is more than one join predicate.
      The following query results in a hash join plan even though there is a valid indexnl hint on one of the predicates.

      select * from R join S on tobigint(R.u64) = S.u64 and tobigint(R.u256) /*+ indexnl(S_u256_idx) */ = S.u256 where R.rand < 10;

      Attachments

        Issue Links

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

          Activity

            People

              vijay.sarathy Vijay Sarathy
              vijay.sarathy Vijay Sarathy
              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