Uploaded image for project: 'Apache Cassandra'
  1. Apache Cassandra
  2. CASSANDRA-7391

Partial indexes

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Open
    • Low
    • Resolution: Unresolved
    • 5.x
    • Legacy/CQL
    • None

    Description

      Indexing extremely common values is not useful (e.g. where 90% of rows have a null value) because it's actually more efficient to just to a seq scan, so indexing is just wasted effort.

      Rather than requiring users to take that hit if they want anything indexed at all, we should allow specifying a WHERE clause to CREATE INDEX specifying which rows to include in the index. Could include UDF but useful even without it.

      http://www.postgresql.org/docs/9.3/static/indexes-partial.html

      Attachments

        Issue Links

          depends upon

          New Feature - A new feature of the product, which has yet to be developed. CASSANDRA-7395 Support for pure user-defined functions (UDF)

          • Normal -
          • Resolved
          relates to

          New Feature - A new feature of the product, which has yet to be developed. CASSANDRA-7461 operator functionality in CQL

          • Normal -
          • Resolved

          Activity

            People

              Unassigned Unassigned
              jbellis Jonathan Ellis
              Votes:
              1 Vote for this issue
              Watchers:
              15 Start watching this issue

              Dates

                Created:
                Updated: