If you mean does it make sense to have a CF where each row contains a set of keys to other rows in another CF, then yes, that's a common design pattern, although usually it's because you're creating collections of those rows (i.e. a Groups CF where each row consists of a set of keys to rows in the Users CF). Not sure if that's what you're getting at, though.
On Thu, Feb 24, 2011 at 9:34 AM, mcasandra <mohitanch...@gmail.com> wrote: > > Generally no. But yes if retrieving the key through index is faster than > going through the hash buckets. > > Currently I am thinking there could be 100s of million or billion of rows > and in that case if we have to retrieve a row which one will be fast going > through hash bucket or index? I am thinking in such scenario Index would be > faster. Please help me understand where I am going wrong. Some example will > be helpful. > -- > View this message in context: > http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Understanding-Indexes-tp6058238p6061197.html > Sent from the cassandra-u...@incubator.apache.org mailing list archive at > Nabble.com. >
