The way to query a CF with "start > 10 and end < 100"

[Guofeng Zhang]

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