We are considering using Hibernate as a persistence layer to our web
application. It seems to only want to do outer joins and this concerns me
b/c they can be expensive. I created the following benchmark experiment and
learned that the explain plan for the two constrained queries is the same.
Boyd,
You can tell Hibernate not to use outer-joins by setting
hibernate.use_outer_join to false in the hibernate configuration
properties file.
It's an always-never proposition. Of course, you can code your own
queries using the Hibernate Query object to write your own when you know
you do ne
