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