[jira] [Updated] (IGNITE-19435) Calcite Engine : Slower than H2 Engine in some join scene.

[YuJue Li (Jira)]

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

YuJue Li updated IGNITE-19435:
------------------------------
    Attachment: 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)