[Hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1940) many-to-one fetch="join|select"

[Christian B. (JIRA) <no...@at...>]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1940?page=comments#action_23757 ] 

Christian Bauer commented on HHH-1940:
--------------------------------------

The benchmarks, execution plans, and result numbers for the most important 5 databases would be enough.


> 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