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:52:00 UTC

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

YuJue Li created IGNITE-19435:
---------------------------------

             Summary: 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: New Feature
          Components: sql
    Affects Versions: 2.15
            Reporter: YuJue Li
             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)