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

Pavel Vinokurov updated IGNITE-8284:
------------------------------------
    Attachment: ignite-8284.zip

> Performance SQL with distinct in subquery
> -----------------------------------------
>
>                 Key: IGNITE-8284
>                 URL: https://issues.apache.org/jira/browse/IGNITE-8284
>             Project: Ignite
>          Issue Type: New Feature
>          Components: sql
>    Affects Versions: 2.4
>            Reporter: Pavel Vinokurov
>            Priority: Major
>         Attachments: ignite-8284.zip
>
>
> A query with distinct in subquery executes much slower in non-local mode than 
> local mode.
> For example we have "person table" with 200000 rows.
> The following query executes at 5ms in local mode, and at 75ms at non local 
> mode.
> select * from
> (select distinct p.id from "Person".Person p left join "Company".Company c on 
> p.companyId=c.id
> where p.name='John' or c.name='Company2') p
> join "Department".Department d on d.id=p.id
> The peproducer project is attached.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to