Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Which one is faster?

Re: Which one is faster?

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Wed, 7 Jul 2004 10:04:53 +0100
Message-ID: <40ebbca7$0$6444$cc9e4d1f@news-text.dial.pipex.com>


"Oracle Newbie" <f93c0532_at_yahoo.com> wrote in message news:2l1dfuF7cgu4U1_at_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 )

Well apart from anything else, the function based version can be indexed if the performance is important.

> > BTW: any reason you didn't try it yourself?
>
> How can I test for speed? I'm using Toad 7.6

generate some representative test data and time several runs, even better use real data and time several runs.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
Received on Wed Jul 07 2004 - 04:04:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US