[CAY-2843] Use an IN clause for single field disjoint by ID prefetches

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 4.2
• Fix Version/s: 5.0-M1
• Component/s: Core Library
• Labels: pull-request-available
• Assignee: Nikita Timofeev
• Reporter: Jurgen Doll
• Created: 07/Feb/24 14:56
• Updated: 12/Jun/24 13:16
• Resolved: 12/Jun/24 13:16

Description

Currently HierarchicalObjectResolver uses "field1 = ? OR field1 = ? ...." pattern for all disjoint by ID prefetches.

I propose distinguishing between single field prefetches and multi-field prefetches, so that the former makes use of an IN clause instead.