[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1940?page=comments#action_23756 ]
Christian Bauer commented on HHH-1940:
--------------------------------------
Please attach benchmarks, SQL execution plans, and result numbers that show that an inner join is a better option for a non-null key two tuple join.
> many-to-one fetch="join|select"
> -------------------------------
>
> Key: HHH-1940
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1940
> Project: Hibernate3
> Type: New Feature
> Components: core
> Reporter: Erik Mathijs
> Priority: Minor
>
>
> if you specify fetch="join" the related object will be loaded using a outer join.
> It would be more performant if you can specify the type of join (outer join, inner join) for example fetch="inner join".
> You can use the fetch="inner join' on foreign key fields that are not null fields in the database table.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
|
