Can you send us the result of a "describe columnfamily users" ?
How many rows are presents in this table ?
Do you have indexes defined ?
What is a "long time" exactly ?
AlainLe 23 août 2013 14:53, "Sávio Teles" <firstname.lastname@example.org> a écrit :
This query takes a long time to run. Any ideas to perform it efficiently?select * from users where user_id = 'x' and age > y and age < z and salary > a and salary < b and age='M';I need to perform range query efficiently. I have the table like:Example of querying:users-------user_id | age | gender | salary | ...The attr user_id is the PRIMARY KEY.
Tks in advance.