On Fri, 11 Feb 2005 09:24:53 -0500, Sami Seerangan <dba.orcl_at_gmail.com> 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
Received on Mon Feb 14 2005 - 13:29:00 CST
