Srdjan Mitrovic created CASSANDRA-5267: ------------------------------------------
Summary: Index organized table Key: CASSANDRA-5267 URL: https://issues.apache.org/jira/browse/CASSANDRA-5267 Project: Cassandra Issue Type: Improvement Reporter: Srdjan Mitrovic Priority: Minor The purpose is to enable very fast scans for queries which use WHERE indexed_column_value='foo'; We could borrow syntax from Oracle (with a small difference). {noformat}CREATE TABLE blog_entries ( posted_at timestamp, blog_id int author text, content text, PRIMARY KEY (posted_at) ) ORGANIZATION INDEX ON (blog_id); {noformat} In the background we could have a CF having only (key, indexed_value), in this case (posted_at, blog_id) so that we can maintain our index when we delete a row or change blog_id, and we would store other values within the index. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira