[hibernate-issues] [JIRA] (HHH-16595) Different SQL queries for @ManyToMany relationships in Hibernate 5 and 6

Johannes Dieckmann ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16595 ( https://hibernate.atlassian.net/browse/HHH-16595?atlOrigin=eyJpIjoiNWViYm... ) Re: Different SQL queries for @ManyToMany relationships in Hibernate 5 and 6 ( https://hibernate.atlassian.net/browse/HHH-16595?atlOrigin=eyJpIjoiNWViYm... ) We are experiencing the exact same performance issues with the new position of the on-clause, except the tables that are joined together are related to „joined inheritance“. We have a base entity class with 30 implementations. Querying 60 of them by its parent entity (out of a total of 300.000) cost about 2,86ms with hibernate 5. Under hibernate 6 it costs 1s 463ms. My attempts to somehow optimize it on postgresql side were not successful. The planner is simply not able to optimize it as before. Would be nice if there was a simple switch to get the old behavior regarding the position of the on-clause. ( https://hibernate.atlassian.net/browse/HHH-16595#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16595#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100234- sha1:aec3a25 )