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 <guofeng@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
>
>