[IGNITE-20881] Add ability to enforce an index to be used

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0
• Component/s: sql
• Labels: ignite-3
• Epic Link: Criteria API queries
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Andrey Novikov
• Reporter: Andrey Novikov
• Reviewer: Andrey Mashenkov
• Created: 17/Nov/23 07:52
• Updated: 04/Sep/24 16:07
• Resolved: 12/Feb/24 10:37

Description

What to do:

• Extend criteria api with index hint

• Generate SQL with hint

• Add a test that verifies that the passed index is used in the query

As reference ignite 2.x documentation can be used https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index

Issue Links

• Blocked: IGNITE-21278 Add FORCE_INDEX/NO_INDEX hints for calcite engine
• links to: GitHub Pull Request #3101