queries start > 10 and end < 100 is not straight forward to modelize, you should use the value of start as column name, and check on client side the second condition.
Just for comparison, modeling 10 < value < 100 is rather much easier if you set your values as column name, or using CompositeType if you have duplicate values. 2011/8/29 Guofeng Zhang <guof...@radvision.com>: > Hi, > > > > I have a standard CF that has column “start” and “end”. I need to query its > rows using condition “start>10 and end<100”. Is there any better way to do > it? Using native secondary index or creating a specific CF for the search. I > do not know which one is better. If the late is preferred to, how the CF > looks like? Your advice is appreciated. > > > > Thanks > >
