Hi all

We have 4 indexed columns; all configured in UT8Type even if one columns is a date and the other an integer). 

1/ the read query we run can have up to 4 criteria
select my_cf where columnA = a and columnB = b and columnC = c and columnD = d

This query, is fast (<500ms) up to 3 criterias but when we add the fourth one, the exection time is 9,5s. 
Do you have any ideas? is there any way to understand how cassandra internally run the query (a kind of "explain plan")? 

2/ Is there any limitations on the number of criterias we can usually have? 

3/ Even if we have different data type (date, string, int), we have all stored them as UTF8Type. Could we expect performance improvements if we use DateType, LongType?

Many thx for all your answers. 

--
............................................................
Olivier Mallassi
OCTO Technology
............................................................
50, Avenue des Champs-Elysées
75008 Paris

Mobile: (33) 6 28 70 26 61
Tél: (33) 1 58 56 10 00
Fax: (33) 1 58 56 10 01

http://www.octo.com
Octo Talks! http://blog.octo.com