Re: replace or translate?

From: Jared Still <jkstill@xxxxxxxxx>
To: dba.orcl@xxxxxxxxx
Date: Mon, 14 Feb 2005 10:26:00 -0800

On Fri, 11 Feb 2005 09:24:53 -0500, Sami Seerangan <dba.orcl@xxxxxxxxx> wrote:
> 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
> 

Which test did you run first?
Did you run them multiple times?
Was the DB cache hot or cold?


-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: replace or translate?
From: Sami Seerangan

References:
- RE: replace or translate?
  - From: Knight, Jon
- Re: replace or translate?
  - From: Sami Seerangan
- Re: replace or translate?
  - From: Bill Coulam
- Re: replace or translate?
  - From: Sami Seerangan

Re: replace or translate?

Other related posts: