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

Index selection varies during query

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Done
    • Major
    • feature-backlog
    • 4.5.1
    • query
    • None

    Description

      CBSE-2996:
      When multiple indexes are created a query will occasionally perform an intersect scan instead of selecting the best performing index to service a query.
      Work around is to include additional field in the index to force the optimizer to select the intended index. While this 'shouldn't' be required it would be good if we weren't forced to use a hint.

      Attachments

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

        Activity

          People

            keshav Keshav Murthy
            justin Justin Michaels (Inactive)
            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