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_at_gmail.com> 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"
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 09 2007 - 14:34:15 CST
