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

Allow creation of indexes which are only used if USE INDEX is specified

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Unresolved
    • Minor
    • feature-backlog
    • 6.6.2, 6.5.2, Cheshire-Cat
    • query, secondary-index
    • None
    • 1

    Description

      It would be useful to be able to create an index in such a way that it is not considered for use within queries unless the USE INDEX directive is specified. Consider creating an adaptive index which indexes the entirety of a document, in theory this index can be used for any query however it may not be the most performant to do so, but is performant for a small subset of queries. Rather than needing to specify USE INDEX on every query you do not want to use this new index for, it would instead be more beneficial to be able to tell the query to use that index, and the index only gets considered for those sorts of queries.

      Have tagged this against both 2I and Query for the time being

      Attachments

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

        Activity

          People

            Unassigned Unassigned
            tim.bradgate Tim Bradgate (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty