[
https://issues.apache.org/jira/browse/IGNITE-19435?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17720296#comment-17720296
]
YuJue Li commented on IGNITE-19435:
-----------------------------------
the explain are as follows:
!2023-05-07_19-57.png!
> Calcite Engine : Slower than H2 Engine in some join scene.
> ----------------------------------------------------------
>
> Key: IGNITE-19435
> URL: https://issues.apache.org/jira/browse/IGNITE-19435
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Affects Versions: 2.15
> Reporter: YuJue Li
> Priority: Major
> Fix For: 2.16
>
> Attachments: 2023-05-07_19-57.png, image-2023-05-06-15-49-25-773.png
>
>
> !image-2023-05-06-15-49-25-773.png!
> PI_COM_DAY is partitioned.
> CREATE INDEX IDX_PI_COM_DAY_ITEM_DATE ON PI_COM_DAY(ITEM_ID,DATE1);
> PLM_ITEM is replicated.
> ITEM_ID is PRIMARY KEY.
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
