Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Which one is faster?
"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