Uploaded image for project: 'Couchbase Java Client'
  1. Couchbase Java Client
  2. JCBC-767

add USE INDEX hint to the n1ql DSL

    XMLWordPrintable

Details

    • New Feature
    • Resolution: Fixed
    • Major
    • 2.2.0-dp2
    • 2.2.0-dp
    • None
    • Security Level: Public
    • None

    Description

      There has recently (ie post N1QL DP4) been the addition of the USE INDEX clause in SELECT (and DML) statements. This hints to use a specific index.

      Example:
      select * from CUSTOMER USE INDEX(VPX_CUSTOMER) limit 1;

      Reference for SELECT:
      https://github.com/couchbase/query/blob/master/docs/n1ql-select.md

      Attachments

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

        Activity

          People

            simonbasle Simon Baslé (Inactive)
            simonbasle Simon Baslé (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty