Uploaded image for project: 'Couchbase Documentation'
  1. Couchbase Documentation
  2. DOC-8301

UNNEST scan use both DISTINCT & ALL index

    XMLWordPrintable

Details

    Description

      https://docs.couchbase.com/server/current/n1ql/n1ql-language-reference/indexing-arrays.html#summary

      UNNEST row only last column Only ALL other two columns must both DISTINCT & ALL

      UNNEST
      		 
       
      		 
      ✓ (both ALL & DISTINCT, with array as leading index-key)
      		 
       
      		 
      ✓ (both ALL & DISTINCT, with array as leading index-key)
      		 
       
      		 
      ✓ (only ALL, with array as leading index-key)

      Attachments

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

        Activity

          People

            simon.dew Simon Dew
            docsite-collector Docs Site Collector
            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