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



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


      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


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


          tim.bradgate Tim Bradgate (Inactive) created issue -
          James Flather James Flather made changes -
          Field Original Value New Value
          Summary Only use index for queries if USE INDEX is specified Allow creation of indexes which are only used if USE INDEX is specified
          Sitaram.Vemulapalli Sitaram Vemulapalli made changes -
          Fix Version/s feature-backlog [ 10342 ]
          Donald.haggart Donald Haggart made changes -
          Assignee Kamini Jagtiani [ kamini.jagtiani ]


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



              Gerrit Reviews

                There are no open Gerrit changes