[ https://issues.apache.org/jira/browse/CASSANDRA-749?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12856309#action_12856309 ]
Jonathan Ellis commented on CASSANDRA-749: ------------------------------------------ Another thought: if you are reading small "pages" worth of indexed rows out at a time, which we've been discussing here as the use case that non-local indexes are good at, then presumably you want the rows in your pages ordered by some property. If this property is the original, base row key (or if the user doesn't care and allows us to pick), then local indexes are just as efficient as non-local under OPP, since you can only query a single replica. (Under RP, you can't do non-local indexes at all, so local indexes still wins.) If the property is NOT the original, base row key, then not matter what kind of index you have, you need to read all the results to sort in the desired order, in which case parallelizing that read is better than not, which you get for free with local indexes; the "index hot spot" reasoning also applies. > Secondary indices for column families > ------------------------------------- > > Key: CASSANDRA-749 > URL: https://issues.apache.org/jira/browse/CASSANDRA-749 > Project: Cassandra > Issue Type: New Feature > Components: Core > Reporter: Gary Dusbabek > Assignee: Gary Dusbabek > Priority: Minor > Fix For: 0.8 > > Attachments: 0001-simple-secondary-indices.patch, > views-discussion-2.txt, views-discussion.txt > > -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira