Re: Unexplainable: "Beautified" code runs slower

From: userjohn <userjohn_at_mailinator.com>
Date: Mon, 1 Oct 2007 11:15:39 -0400
Message-ID: <13g23rk3941b345@corp.supernews.com>

"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;" Received on Mon Oct 01 2007 - 10:15:39 CDT