Hi, I have created a local index for every column in my table. Lets say my primary key is P_KEY and columns are COL1, COL2, etc
When i do the query - "SELECT P_KEY FROM TABLENAME WHERE COL1='xxx'" It is scanning only the local index, and returning the results fast. But when i query - "SELECT P_KEY FROM TABLENAME WHERE COL1='xxx' AND COL2='yyy'", I expected that it would still scan two local indexes only and merge the results. Instead, it is scanning the full table. I think there is already the JIRA for this - https://issues.apache.org/jira/browse/PHOENIX-1801 But considering that such queries are most frequent in our use case, is Phoenix not suitable for this ? Thanks, Chaitanya -- View this message in context: http://apache-phoenix-user-list.1124778.n5.nabble.com/Index-merge-join-for-multiple-where-clause-tp3637.html Sent from the Apache Phoenix User List mailing list archive at Nabble.com.
