Re: tracing makes the sql run faster
- From: ryan_gaffuri@xxxxxxxxxxx
- To: Prasada.Gunda@xxxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 01 Nov 2004 20:56:55 +0000
if you do not analyze your tables or your stats are out-dated the moon can
change query plans.
also, does setting trace on force the CBO to run and you could be defaulting to
the RBO(I can't remember if this does it or not... I don't think so).
> Hello All,
>
> We have an application which uses Oracle Forms 6i. One particular query
> takes very long time when it runs in the forms application. When I trace
> the user session to see what was going on, surprisingly query runs much
--
//www.freelists.org/webpage/oracle-l
Other related posts:
