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

Add Support for Composite Atomic-Array Indexes

    XMLWordPrintable

Details

    • 1
    • CX Sprint 258, CX Sprint 259, CX Sprint 260

    Description

      Copy of ASTERIXDB-2829.

      Currently array indexes only support indexing on the elements of an array. It would be beneficial to add atomic fields as prefix(es) / suffix(es) to an array index, to allow for more queries to use an array index as an access method.

       

      As it stands composite array indexes are allowed in the grammar and should be maintainable (i.e. bulk loading, insert, delete, and upserts should work), but care must be given when recognizing that the index is applicable. In the IntroduceSelectAccessMethodRule, we currently only attempt to optimize a single SELECT (and thus, only keep context for that specific SELECT)- but applicable composite atomic-array index queries have SELECTs that span multiple levels (one before the unnest and one after).

      Attachments

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

        Activity

          People

            glenn.galvizo Glenn Galvizo
            glenn.galvizo Glenn Galvizo
            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