abhishek created PHOENIX-16:
-------------------------------
Summary: Join Query optimization
Key: PHOENIX-16
URL: https://issues.apache.org/jira/browse/PHOENIX-16
Project: Phoenix
Issue Type: Improvement
Affects Versions: 3.0.0
Reporter: abhishek
select * from t1 inner join t2 on t1.col1 = t2.col2 where t1.id < 1000 and
t2.id < 1000
For above query, phoenix first join the tables t1 and t2, and then apply the
filter t1.id < 1000 and t2.id < 1000. This is very inefficient. This can be
easily fixed by pushing the filter operation before the join query.
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
