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

CBO not choosing indexnl join when there are multiple join predicates

Details

    • Bug
    • Resolution: Unresolved
    • 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

        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:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty