[
https://issues.apache.org/jira/browse/IGNITE-8284?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pavel Vinokurov updated IGNITE-8284:
------------------------------------
Description:
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.
> 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
>
> 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)
