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

[CX] A prefix-based LIKE query should utilize an available index

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Unresolved
    • Major
    • Morpheus
    • CBAS DP3
    • analytics

    Description

      A LIKE query such as

      SELECT VALUE br
      FROM beers br
      WHERE br.brewery_id LIKE 'kona%';

      should really use an index much like the following query would:

      SELECT VALUE br
      FROM beers br
      WHERE br.brewery_id >= 'kona' AND br.brewery_id < 'konb' ;

      Attachments

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

        Activity

          People

            vijay.sarathy Vijay Sarathy
            mike.carey Mike Carey
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty