Re: Query Question - Fetches

Ok, so the question should be asked why do inline function perform so poorly with Oracle. I've encountered this problem. In our case, it was often *simple* user-defined functions used within the WHERE criteria. ( as opposed to built-in Oracle functions like RTRIM ) SQLServer handled these same functions without a performance problem, Oracle did not.

It seems you just need to be careful when using inline function with your query statements, particularly in the WHERE clause.

Kurt

-- 


----------------------------------------------------
This mailbox protected from junk email by MailFrontier Desktop
from MailFrontier, Inc. http://info.mailfrontier.com

"Sybrand Bakker" <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote in
message news:hv3np0d07tli1i2fbiut6hti1me15bh7m6_at_4ax.com...


> On 17 Nov 2004 07:01:07 -0800, amerar_at_iwc.net (Arthur) wrote:

>

> >So, my question is:  Why do the function calls raise the number of

> >fetches?

>

> Read your tkprof output *carefully*. What is the *number of fetches*

> (under the 'count' label). In *both* cases 19.

>

> I rest my case.

>

>

> --

> Sybrand Bakker, Senior Oracle DBA