Re: Performance Hit for REPLACE Function?

Ryan Kapil <frankrizzo2k_at_hotmail.com> schreef in berichtnieuws _LeR4.70791$O7.158563_at_typhoon.southeast.rr.com...
> Will there be a decline in performance if I add the REPLACE function to my
> SELECT statement to eliminate quotation marks from the results? For
 example:
>
> SELECT REPLACE(a.first_name, '"'), REPLACE(a.last_name, '"').............
>
> Would the size of the tables being queried or the size of the result set
> affect if the REPLACE function hurts performance?
>
> Thanks,
> Ryan
>

The only 'decline' is the time to execute the replace function. As to your second question: this is absolute nonsense. The replace function is a function: it transforms an expression, it doesn't read, it doesn't write, etc.
Obviously, you are a newbie. Please read up on Oracle Concepts.

Hth,
Sybrand Bakker, Oracle DBA

>
Received on Sun May 07 2000 - 00:00:00 CDT