Re: replace or translate?
- From: Sami Seerangan <dba.orcl@xxxxxxxxx>
- To: Bill Coulam <bcoulam@xxxxxxxxx>
- Date: Fri, 11 Feb 2005 09:24:53 -0500
Thanks to Bill and everyone who responded.
I ran a test case on 10M rows (do have complex strings) with two
nested REPLACE calls vs. a simple TRANSLATE. The result is opposite to
yours.
Replace took 13 mins
Translate took 20 mins
On Thu, 10 Feb 2005 19:03:14 -0600, Bill Coulam <bcoulam@xxxxxxxxx> wrote:
> I ran a number of tests on 125K rows with three nested REPLACE calls
> vs. a simple TRANSLATE. On my box, the translate is not only cleaner
> to code, but edged out the REPLACE by a second every time. 'Course if
> I were replacing some complex string, I wouldn't even know where to
> being if I were forced to use TRANSLATE; I'd turn to REPLACE.
>
> - bill c.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
