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

Home -> Community -> Usenet -> c.d.o.server -> Performance hit on REPLACE function?

Performance hit on REPLACE function?

From: Ryan Kapil <frankrizzo2k_at_hotmail.com>
Date: 2000/05/07
Message-ID: <bbjR4.70933$O7.160435@typhoon.southeast.rr.com>#1/1

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 Received on Sun May 07 2000 - 00:00:00 CDT

Original text of this message

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