[
https://issues.apache.org/jira/browse/IGNITE-13316?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17169266#comment-17169266
]
Xie Bo commented on IGNITE-13316:
-
Can Ignite optimize the LEFT JOIN to INNER JOIN if the {{WHERE}}
[
https://issues.apache.org/jira/browse/IGNITE-13316?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17169732#comment-17169732
]
Xie Bo commented on IGNITE-13316:
-
Hi [~ilyak],
Thanks very much for your advice!
I have added an
Xie Bo created IGNITE-13316:
---
Summary: The left join table's index is not used in Ignite SQL
execution
Key: IGNITE-13316
URL: https://issues.apache.org/jira/browse/IGNITE-13316
Project: Ignite
[
https://issues.apache.org/jira/browse/IGNITE-13316?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Xie Bo updated IGNITE-13316:
Component/s: (was: springdata)
sql
> The left join table's index is not used in
[
https://issues.apache.org/jira/browse/IGNITE-13316?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Xie Bo updated IGNITE-13316:
Description:
SELECT * FROM issue LEFT JOIN issue_fixed_version ver ON issue.id=ver.id WHERE
[
https://issues.apache.org/jira/browse/IGNITE-13316?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Xie Bo updated IGNITE-13316:
Description:
SELECT * FROM issue LEFT JOIN issue_fixed_version ver ON issue.id=ver.id WHERE
