Hi Jonathan, I tried the same query using hints -
/SELECT /*+ INDEX(TABLENAME COL1_LOCAL_INDEX COL2_LOCAL_INDEX) */ P_KEY FROM TABLENAME WHERE COL1='xxx' AND COL2='yyy'"/ This seems to only take first index into account and throws error - COL2 not found. Thanks Chaitaya -- View this message in context: http://apache-phoenix-user-list.1124778.n5.nabble.com/Index-merge-join-for-multiple-where-clause-tp3637p3639.html Sent from the Apache Phoenix User List mailing list archive at Nabble.com.
