Re: Why functions in Select Clause affect performance?

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Wed, 05 Apr 2006 08:33:01 GMT
Message-ID: <44337fca.6803765@news.hetnet.nl>

On 4 Apr 2006 11:17:23 -0700, "Kin" <kin_ng5_at_yahoo.com> wrote:

<snip>
>What puzzles me is it seems the functions in the Select clause are NOT
>always run against the final result set but some intermediate ones.
<snip>

Build a counter into the function and check. To be able to initialize the counter use DBMS_APPLICATION_INFO or put the function in a package with a global variable.

Jaap. Received on Wed Apr 05 2006 - 03:33:01 CDT

This message: [ Message body ]
Next message: rankbishop_at_yahoo.com: "Backup en Caliente"
Previous message: Jaap W. van Dijk: "Re: Is it possible in SQL or PL/SQL"
In reply to: Kin: "Why functions in Select Clause affect performance?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US