Alberto, There shouldn't be a problem with using the ANSI joins if using CBO. I just prefer looking at the oracle non ANSI joins. Just what I'm used to and comfortable with. Hibernate In Action is a pretty good book on the subject. Unfortunately, I think it still only covers up to version 2 of hibernate. The online docs have a lot of good info as well. Good luck. John On 2/9/07, Alberto Dell'Era <alberto.dellera@xxxxxxxxx> wrote:
Thanks John - our version is 10g, CBO is definitely going to be used; in this environment, do you foresee any difference in overriding the ANSI join setting ? On 2/9/07, John Darrah <darrah.john@xxxxxxxxx> wrote: > 10046 trace is your friend when trying to tune hibernate apps. If your > database is > oracle 8i and still using RBO, you'll want to override the > setting that tells hibernate to use ANSI sql joins (you want to do this > regardless in my opinion) as not doing so forces a cost based plan. -- Alberto Dell'Era "Per aspera ad astra"