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

Update costing of index NL joins

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Major
    • Goldfish GA
    • Goldfish GA
    • analytics
    • 0
    • Analytics Sprint 40, Analytics Sprint 41, Analytics Sprint 42

    Description

      We were picking an NL join incorrectly for this query. The NL is a lot slower than a HJ.

      select sum(l.l_extendedprice * (1 - l.l_discount)) as revenue
      from orders o, lineitem l
      where  l.l_orderkey   = o.o_orderkey
      and o.o_orderdate  >= '1993-01-01' and o.o_orderdate < '1994-01-01';
      

      Attachments

        Issue Links

          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:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty