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
wrote:
> 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 Accou
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 FROM COMPANYCF WHERE COMPANY='XXX' AND ACCOUNTNUMBER = 'YYY'
Even though ACCOUNTNUMBER based Index is a better
