Re: Which one is faster?

From: Oracle Newbie <f93c0532_at_yahoo.com>
Date: Wed, 7 Jul 2004 09:46:31 +0500
Message-ID: <2l1dfuF7cgu4U1@uni-berlin.de>

"Sybrand Bakker" <sybrandb_at_hccnet.nl> wrote in message news:phvme0p53ds1h41i8efbgmlqjqj034d6pq_at_4ax.com...
> On Wed, 7 Jul 2004 09:32:24 +0500, "Oracle Newbie"
> <f93c0532_at_yahoo.com> wrote:
>
> >I have a string of thousands of characters and I want to check if it ends
> >with '>>' There are 2 ways of doing it ( or more maybe)
> >
> >If big_str like '%>>' Then
> >
> >OR
> >
> >If substr(big_str , length(big_str) - 1 , 2 ) = '>>' Then
> >
> >Which one is faster? obviously the 1st one is simpler.
> >
> >Or is there a better way?
> >
> >thx
> >
>
> The second looks faster to me.

Why? ( esp. when it contains two functions )

> BTW: any reason you didn't try it yourself?

How can I test for speed? I'm using Toad 7.6

thx
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Tue Jul 06 2004 - 23:46:31 CDT