[CASSANDRA-9181] Improve index versus secondary index selection

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Not A Problem
• Component/s: Feature/2i Index
• Labels: 2i
• Assignee: Unassigned
• Reporter: Jeremy Hanna
• Created: 13/Apr/15 18:49
• Updated: 16/Apr/19 09:31
• Resolved: 15/Feb/16 11:18

Description

There is a special case for secondary indexes if you always supply the partition key. For example, if you have a family with ID "a456" which has 6 family members and I have a secondary index on first name. Currently, if I do a query like this "select * from families where id = 'a456' and firstname = 'alowishus';" you can see from a query trace, that it will first scan the entire cluster based on the firstname, then look for the key within that.

If it's not terribly invasive, I think this would be a valid use case to narrow down the results by key first.