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

Posted to dev@ignite.apache.org by "Vladimir Ozerov (JIRA)" <ji...@apache.org> on 2017/08/28 12:45:00 UTC

[jira] [Created] (IGNITE-6201) SQL: support merge join

Vladimir Ozerov created IGNITE-6201:
---------------------------------------

             Summary: SQL: support merge join 
                 Key: IGNITE-6201
                 URL: https://issues.apache.org/jira/browse/IGNITE-6201
             Project: Ignite
          Issue Type: Task
          Components: sql
    Affects Versions: 2.1
            Reporter: Vladimir Ozerov


It looks like currently the only way to join data is {{nested loops}} approach. While being perfectly fine for small tables, this approach is terribly inefficient for joins on large tables. We need to make sure that merge join technique is used instead if join is performed on sorted attributes.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)