At blog I see below statement
Secondary indexes are a first-class construct in MongoDB. This makes it easy to index any property of an object stored in MongoDB even if it is nested. This makes it really easy to query based on these secondary indexes. Cassandra has only cursory support for secondary indexes. Secondary indexes are also limited to single columns and equality comparisons.
I have two related questions on it .
Cassandra has only cursory support for secondary indexes.
Not sure what makes Mongo to have better support than cassandra which just has cursory support ?
Secondary indexes[Cassandra] are also limited to single columns
My understanding on above statement is that cassandra supports secondary indexes only on single column not on composite column
Secondary indexes[Cassandra] are also limited to equality comparisons. I believe it means Mongo can use index for greater/lass than operation also but cassandra is limited to equality ?
My understanding is Mongo implements the secondar index in similar fashion as RDBMS but not sure how cassandra implements it at high level ?