Re: replace or translate?

Jared,

Thanks for your response. I did run both cases multiple times, tried in diff order too.

For character replacement,I was also under the same impression that TRANSLATE will defeat REPLACE but it is not.

On Mon, 14 Feb 2005 10:26:00 -0800, Jared Still <jkstill_at_gmail.com> wrote:
> 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
>

-- 
Sami Seerangan
Oracle DBA
HSBC.com
--
http://www.freelists.org/webpage/oracle-l