[IGNITE-20255] Query join order SQL hint.

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.16
• Labels: important ise
• Release Note: SQL Calcite: Added ENFORCE_JOIN_ORDER hint
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Vladimir Steshin
• Reporter: Vladimir Steshin
• Created: 20/Aug/23 10:40
• Updated: 26/Oct/23 17:47
• Resolved: 26/Oct/23 17:47

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 analogy is 'ORDERED'. Looks simple, allows to keep join order. Also, can prevent long joins planning by Calcite.

Issue Links

• links to: GitHub Pull Request #10910