incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sávio Teles <savio.te...@lupa.inf.ufg.br>
Subject How to perform range queries efficiently?
Date Fri, 23 Aug 2013 12:53:07 GMT
I need to perform range query efficiently. I have the table like:

users
-------
user_id | age | gender | salary | ...

The attr user_id is the PRIMARY KEY.

Example of querying:

select * from users where user_id = '*x*' and age > *y *and age < *z* and
salary > *a* and salary < *b  *and age='M';

This query takes a long time to run. Any ideas to perform it efficiently?

Tks in advance.


-- 
Atenciosamente,
Sávio S. Teles de Oliveira
voice: +55 62 9136 6996
http://br.linkedin.com/in/savioteles
Mestrando em Ciências da Computação - UFG
Arquiteto de Software
Laboratory for Ubiquitous and Pervasive Applications (LUPA) - UFG

Mime
View raw message