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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
