Choice of Index

2011-05-11 Thread Baskar Duraikannu
Hello - I am using 0.8 Beta 2 and have a CF containing COMPANY, ACCOUNTNUMBER and some account related data. I have index on both Company and AccountNumber. If I run a query - SELECT DATA FROM COMPANYCF WHERE COMPANY='XXX' AND ACCOUNTNUMBER = 'YYY' Even though ACCOUNTNUMBER based Index is a

Re: Choice of Index

2011-05-11 Thread Jonathan Ellis
No, Cassandra uses statistics to see which index will result in less rows to check. On Wed, May 11, 2011 at 12:42 PM, Baskar Duraikannu baskar.duraikannu...@gmail.com wrote: Hello - I am using 0.8 Beta 2 and have a CF containing COMPANY, ACCOUNTNUMBER and some account related data.  I have