The key structure you have should group the keys based on the website. There are some differences between range queries with RP and OPP this article may help http://ria101.wordpress.com/2010/02/22/cassandra-randompartitioner-vs-orderpreservingpartitioner/  Aaron On 15 Jul, 2010,at 08:44 AM, S Ahmed wrote: > Where is the link that describes the various key types and their impact on sorting? (I believe I read it before, can't seem to find it now). > > So my application supports multi-tenants, so I need the keys to represent things like: > > website1123 + contentID > > or > > website3454 + userID > > And for range queries, these keys have to be grouped together obviously. > > What key type would be best suited for this? > > > I might have to create a CF that maps the website and its key prefix?