You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2014/03/14 07:42:43 UTC

[jira] [Created] (PHOENIX-852) Optimize child/parent foreign key joins

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)