wangweiyi created PHOENIX-3310:
----------------------------------

             Summary: where clause optimization in join queries work not well
                 Key: PHOENIX-3310
                 URL: https://issues.apache.org/jira/browse/PHOENIX-3310
             Project: Phoenix
          Issue Type: Improvement
    Affects Versions: 4.8.0
            Reporter: wangweiyi


select * from xxx x join yyy y on x.col1=y.col1 where x.col1='1'
select * from xxx x join yyy y on x.col1=y.col1 where y.col1='1'

the column "col1" is the primary key for table "xxx" and table "yyy"

the above SQL do full scan over either table "xxx" or "yyy". if the join 
compiler take the where clause into account, this can be optimized.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to