You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@ignite.apache.org by "YuJue Li (Jira)" <ji...@apache.org> on 2023/05/06 07:53:00 UTC

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

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

YuJue Li updated IGNITE-19435:
------------------------------
    Issue Type: Improvement  (was: New Feature)

> 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: 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)