phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From cmbendre <chaitanya.ben...@zeotap.com>
Subject Re: Index merge / join for multiple where clause
Date Tue, 06 Jun 2017 07:28:56 GMT
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.

Mime
View raw message