[IGNITE-15522] IndexQuery should perform index scan if no criteria set

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.12
• Labels: IEP-71
• Release Note: IndexQuery can scan PK indexes
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Maksim Timonin
• Reporter: Maksim Timonin
• Created: 16/Sep/21 10:16
• Updated: 15/Dec/21 08:57
• Resolved: 15/Oct/21 06:44

Description

Currently impossible to return full index range with existing IndexQuery criteria. There are  workarounds like `lte(Integer.MAX_VALUE)`. But it will be much better enable index scan by default if not criteria set. It's useful by reasons:

1. In some cases IndexQuery is faster then ScanQuery. Then IndexQuery should have same API as ScanQuery for such cases - new IndexQuery(tbl, idxName)
2. IndexQuery criteria performs AND operation. There is no way to set OR. setFilter is only way to specify custom rule non-AND rule for IndexQuery. So we need allow to use only filter without any criteria.

 

If index name isn't specified then IndexQuery should take PK index of specified table.

Issue Links

• links to: GitHub Pull Request #9463