James Taylor created PHOENIX-852:
------------------------------------

             Summary: Optimize child/parent foreign key joins
                 Key: PHOENIX-852
                 URL: https://issues.apache.org/jira/browse/PHOENIX-852
             Project: Phoenix
          Issue Type: Bug
            Reporter: James Taylor
            Assignee: Maryann Xue


Often times a join will occur from a child to a parent. Our current algorithm 
would do a full scan of one side or the other. We can do much better than that 
if the HashCache contains the PK (or even part of the PK) from the table being 
joined to. In these cases, we should drive the second scan through a skip scan 
on the server side.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to