Re: Unexplainable: "Beautified" code runs slower

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Mon, 01 Oct 2007 06:27:58 -0700
Message-ID: <1191245278.382772.204090@n39g2000hsh.googlegroups.com>

On Oct 1, 7:53 am, Maxim Demenko <mdeme..._at_gmail.com> wrote:
> Yet one possibility - go to Debugger tab page, disable the "Add debug
> information when compiling" and recompile.
>
> Best regards
>
> Maxim

John

You need to run the traces. You are surely looking at one or more resulting changes in the plans being the cause of the difference in run time.

One possible cause would be the use of stored outlines associated with the SQL in the reformatted procedures. It would be worth checking to see if any stored outlines or Profiles are in use.

HTH -- Mark D Powell -- Received on Mon Oct 01 2007 - 08:27:58 CDT