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

Skip-key for composite index

    XMLWordPrintable

Details

    • Task
    • Status: Closed
    • Major
    • Resolution: Done
    • None
    • None
    • documentation, query
    • DOC-2019-S06-Mar22

    Description

      1. Use a composite index with predicate pushdown even with skipping some of the keys. There should be a predicate on THE LEADING KEY and then any of the subsequent predicates.
      2. Arbitrary UNNEST alias.

      Attachments

        Issue Links

          relates to

          Improvement - An improvement or enhancement to an existing feature or task. MB-30422 Ability push non-leading non-continuous predicate to indexer

          • Major - Major loss of function.
          • Closed
          links to

          Web Link Implemented by PR #392

          mentioned in

          Page Loading...

          Page Loading...

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

          Activity

            Ascending order - Click to sort in descending order
            simon.dew Simon Dew created issue -
            simon.dew Simon Dew made changes -
            Field Original Value New Value
            Link This issue relates to MB-30422 [ MB-30422 ]
            simon.dew Simon Dew made changes -
            Description [Dev spec|https://docs.google.com/document/d/1mFTfSabcgtY3ToA-gWSF9H3G8KySbTRrtVJRjGjk0ps/edit#] 1. Use a composite index with predicate pushdown even with skipping some of the keys. There should be a predicate on THE LEADING KEY and then any of the subsequent predicates.
            2. Arbitrary UNNEST alias.
            simon.dew Simon Dew made changes -
            Sprint DOC-2019-S06-Mar22 [ 758 ]
            simon.dew Simon Dew made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            simon.dew Simon Dew made changes -
            Actual Start 2019-03-15 06:09 (issue has been started)
            simon.dew Simon Dew made changes -
            Status In Progress [ 3 ] In Review [ 10107 ]
            simon.dew Simon Dew made changes -
            Status In Review [ 10107 ] Resolved [ 5 ]
            simon.dew Simon Dew made changes -
            Status Resolved [ 5 ] Reopened [ 4 ]
            simon.dew Simon Dew made changes -
            Resolution Done [ 6 ]
            Status Reopened [ 4 ] Closed [ 6 ]
            simon.dew Simon Dew made changes -
            Actual End 2019-03-18 17:25 (issue has been closed)
            simon.dew Simon Dew made changes -
            Remote Link This issue links to "Implemented by PR #392 (Web Link)" [ 18004 ]
            amarantha.kulkarni Amarantha Kulkarni (Inactive) made changes -
            Remote Link This issue links to "Page (Couchbase, Inc. Wiki)" [ 18045 ]
            amarantha.kulkarni Amarantha Kulkarni (Inactive) made changes -
            Remote Link This issue links to "Page (Couchbase, Inc. Wiki)" [ 18065 ]
            amarantha.kulkarni Amarantha Kulkarni (Inactive) made changes -
            Remote Link This issue links to "Page (Couchbase, Inc. Wiki)" [ 19485 ]
            amarantha.kulkarni Amarantha Kulkarni (Inactive) made changes -
            Remote Link This issue links to "Page (Couchbase, Inc. Wiki)" [ 19485 ]

            People

              simon.dew Simon Dew
              simon.dew Simon Dew
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty