[
https://issues.apache.org/jira/browse/IGNITE-20255?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vladimir Steshin updated IGNITE-20255:
--------------------------------------
Description: For the join operations, we should have several SQL hints.
Like join order or join type. One of them is the query join order hint. Oracle
DB's analogue is 'ORDERED'. Looks simple and allows to keep join order and
avoid long join planning by Calcite. (was: For the join operations, we should
have several SQL hints. One of them are the forced join order hints. Oracle
DB's analogue would be 'ORDERED', 'LEADING'. Might be combined with join
operation type like merge, hash, nl like 'USE_NL', 'USE_MERGE')
> Forced join order SQL hint.
> ---------------------------
>
> Key: IGNITE-20255
> URL: https://issues.apache.org/jira/browse/IGNITE-20255
> Project: Ignite
> Issue Type: Task
> Reporter: Vladimir Steshin
> Assignee: Vladimir Steshin
> Priority: Major
> Labels: ise
>
> For the join operations, we should have several SQL hints. Like join order or
> join type. One of them is the query join order hint. Oracle DB's analogue is
> 'ORDERED'. Looks simple and allows to keep join order and avoid long join
> planning by Calcite.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
