Re: Unexplainable: "Beautified" code runs slower

On Oct 1, 4:15 pm, "userjohn" <userj..._at_mailinator.com> wrote:
> "Niall Litchfield"
>
> > 1. The code itself - you say it hasn't but is that actually true.
>
> > difficult for us to tell without seeing either bit.
>
> > 2. The included sql statements have changed (the whitespace,
> > capitilisation etc have changed) and so have been reparsed generating
> > new plans.
>
> thanks for the inputs Niall,
>
> 1, Well I've been doing this repeatedly back and forth btw original and
> pretty code
> for 2 straight days (24 hours in total at least) and have never caused the
> code to not compile right away.
> (I've been doing "sanity check" to the point I'm about to go insane ;) )
>
> 2. Are you saying this ?:
>
> "Selec * From emp
> WHere
> eNAME = l_variable;"
>
> is different from
>
> "SELECT *
> FROM emp
> WHERE ename = l_variable;"

Indeed

see http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/memory.htm#i34548 for example. Received on Mon Oct 01 2007 - 15:20:42 CDT