cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Ellis (JIRA)" <>
Subject [jira] [Created] (CASSANDRA-7391) Partial indexes
Date Thu, 12 Jun 2014 19:35:01 GMT
Jonathan Ellis created CASSANDRA-7391:

             Summary: Partial indexes
                 Key: CASSANDRA-7391
             Project: Cassandra
          Issue Type: New Feature
          Components: API, Core
            Reporter: Jonathan Ellis
            Priority: Minor
             Fix For: 3.0

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.

This message was sent by Atlassian JIRA

View raw message