Jeremy Hanna created CASSANDRA-9181: ---------------------------------------
Summary: Improve index versus secondary index selection Key: CASSANDRA-9181 URL: https://issues.apache.org/jira/browse/CASSANDRA-9181 Project: Cassandra Issue Type: Bug Components: Core Reporter: Jeremy Hanna 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332)