Hi If I have a WHERE clause in CQL with several 'AND' and each column is indexed, which index(es) is(are) used ? Just the first field in the where clause or all the indexes involved in the clause ?
Also is index used only with an equality operator or also with greater than /less than comparator as well ? Thanks.
