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
