I have a question about the performance of the local index in Apache Phoenix
For example, I have a table TBL_X having 6 columns (A , B ,C ,D E, F).
1. Primary Key is (A, B)
2. One of the query patterns is "Select * from TBL_X where A = 'val1' and C = 'val3' "
For the better performance of the above query, I try to build the local index.
Does [ Local index on (C, A) ] perform better than [ Local index on (C) ] ??
Will there be no performance difference since A is already in the first part of the PK ??