Indexing

An index provides a means to access data in DataStax Enterprise using attributes other than the partition key for fast, efficient lookup of data that matches a given condition.

An index provides a means to access data in DataStax Enterprise using attributes other than the partition key. The benefit of an index is fast, efficient lookup of data that matches a given condition. The index indexes column values in a hidden table separate from the table that contains the values being indexed. A number of techniques exist for guarding against the undesirable scenario where data might be incorrectly retrieved during a query based on stale values in an index.

Indexes can be used for collections, collection columns, static columns, and any other columns except counter columns.