Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Performance Hit for REPLACE Function?
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
![]() |
![]() |