Getting Browse screen to use INNER JOIN not OUTER JOIN

Support
#1

We have a browse screen that is looking at around 500k entries in the database. The view for the screen is also bringing in some related entities matched by @ManyToOne annotations.

We can see the SQL queries generated are using LEFT OUTER JOINs to join the tables together. However that is a slow query in the large dataset and we need it to do just a JOIN for efficiency. Putting the fields as @NonNull etc doesn’t seem to affect the SQL generated. How can we make it do the inner rather than outer join?

#2

Hi,
Have you tried to set nullable = false in the @JoinColumn annotation, and optional = false in the @ManyToOne annotation?