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

Posted to issues@ignite.apache.org by "Vladimir Ozerov (JIRA)" <ji...@apache.org> on 2018/03/21 13:01:00 UTC

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

     [ https://issues.apache.org/jira/browse/IGNITE-6201?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Vladimir Ozerov updated IGNITE-6201:
------------------------------------
    Labels: sql-engine  (was: performance)

> 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
>            Priority: Major
>              Labels: sql-engine
>
> 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
(v7.6.3#76005)