Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Performance Hit for REPLACE Function?

Re: Performance Hit for REPLACE Function?

From: Bob Fazio <rfazio_at_home.com.nospam>
Date: 2000/05/08
Message-ID: <e5oR4.176616$Tn4.1344585@news1.rdc2.pa.home.com>#1/1

See Below,

--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"Ryan Kapil" <frankrizzo2k_at_hotmail.com> wrote in message
news:_LeR4.70791$O7.158563_at_typhoon.southeast.rr.com...

> Will there be a decline in performance if I add the REPLACE function to my
Somewhat but if you need the " removed, then you need to do it.
> 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?
Will the performace of the query with a replace be effected more by a large table or result set? No, other than if the replace adds 1/10000 of a second to a query, then every 10,000 rows will be a second longer. By the way, that is about the amount of time that we are talking about, and most likely less.
>
> Thanks,
> Ryan
>
>
Received on Mon May 08 2000 - 00:00:00 CDT

Original text of this message

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