Uploaded image for project: 'Couchbase Lite'
  1. Couchbase Lite
  2. CBL-121

Create partial indexes with NOT NULL to reduce index size

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Duplicate
    • Major
    • postHelium
    • 2.0.0
    • LiteCore
    • Security Level: Public
    • 5

    Description

      https://github.com/couchbase/couchbase-lite-core/issues/244

      Now that we're on the latest SQLite, we can use the Partial Indexes feature, i.e. a WHERE clause in a CREATE INDEX. This will be useful in the indexes we generate, to avoid having lots of null values in the index for docs that don't contain the property/expression.

      Attachments

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

        Activity

          People

            The Lite The Lite
            jimb Jim Borden
            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