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

[Anton Vinogradov (Jira)]

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)