Uploaded image for project: 'Couchbase Gateway'
  1. Couchbase Gateway
  2. CBG-1253

Add USE INDEX to index readiness queries

    XMLWordPrintable

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 3.0
    • SyncGateway
    • Security Level: Public
    • None
    • CBG Sprint 65
    • 3

    Description

      The Sync Gateway index readiness queries don't include USE INDEX (like the standard queries do).  Adding these will ensure index readiness doesn't return a false positive, and avoid expensive query operations when using incorrect indexes.

      Attachments

        Issue Links

          is cloned by

          Improvement - An improvement or enhancement to an existing feature or task. CBG-1270 [2.8.1 Backport] CBG-1253 - Add USE INDEX to index readiness queries

          • Major - Major loss of function.
          • Resolved
          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            Ascending order - Click to sort in descending order
            build-team Couchbase Build Team added a comment -

            Build sync_gateway-3.0.0-106 contains sync_gateway commit 896ea3b with commit message:
            CBG-1253 - Add USE INDEX hints to readiness queries (#4918)

            build-team Couchbase Build Team added a comment - Build sync_gateway-3.0.0-106 contains sync_gateway commit 896ea3b with commit message: CBG-1253 - Add USE INDEX hints to readiness queries (#4918)
            build-team Couchbase Build Team added a comment -

            Build sync_gateway-2.8.1-3 contains sync_gateway commit 586fb79 with commit message:
            [2.8.1 Backport] - CBG-1253 - Add USE INDEX hints to readiness queries (#4918) (#4919)

            build-team Couchbase Build Team added a comment - Build sync_gateway-2.8.1-3 contains sync_gateway commit 586fb79 with commit message: [2.8.1 Backport] - CBG-1253 - Add USE INDEX hints to readiness queries (#4918) (#4919)

            People

              ben.brooks Ben Brooks
              adamf Adam Fraser
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty