[CAY-2684] Use EXISTS subquery for expressions using to-many related entities

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Fix Version/s: 5.0-M2
• Component/s: Core Library
• Assignee: Nikita Timofeev
• Reporter: Nikita Timofeev
• Created: 09/Oct/20 13:55
• Updated: 13/Jun/24 12:28

Description

Using EXISTS() subquery instead of the JOIN for expressions using paths on to-many related entities could boost performance significant in some cases.
As support for the subqueries already implemented per CAY-2468, this should be relatively easy.