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

LOOKUP JOIN not using covering index on LEFT side

    XMLWordPrintable

Details

    • Untriaged
    • Yes

    Description

      CREATE INDEX ix20 ON default(k0,k1);
      EXPLAIN SELECT d1.k0,d1.k1,d2.k3 FROM default d1 JOIN default d2 ON KEYS d1.k1 WHERE d1.k0 =1 ;
      

      In above query d1 can be covered and d2 is not covered due to lookup join.
      When we add d2.k3 in projection or predicate it makes d1 uncovered even though index ix20 has all the info

      This looks like regression of MB-22112

      Attachments

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

        Activity

          People

            Prerna.Manaktala Prerna Manaktala (Inactive)
            Sitaram.Vemulapalli Sitaram Vemulapalli
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty