RE: Secondary indexes and cardinality

2012-02-13 Thread Tiwari, Dushyant
Perfect, Aaron, Thanks a lot From: aaron morton [mailto:aa...@thelastpickle.com] Sent: Tuesday, February 14, 2012 12:54 AM To: user@cassandra.apache.org Subject: Re: Secondary indexes and cardinality Heard that indexing a field with high cardinality is not good. http://www.datastax.com/docs

Re: Secondary indexes and cardinality

2012-02-13 Thread aaron morton
> Heard that indexing a field with high cardinality is not good. http://www.datastax.com/docs/0.7/data_model/secondary_indexes > Will there be any performance improvement? Is this the way secondary indexes > are maintained? Updating secondary indexes requires a read and a write. > Also this ma

Secondary indexes and cardinality

2012-02-13 Thread Tiwari, Dushyant
Hi Cassandra Users, Heard that indexing a field with high cardinality is not good. If we create a CF to store the index information like indexed field as key and the keys of original CF as cols in the row. Will there be any performance improvement? Is this the way secondary indexes are maintain