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: Mark D Powell <Mark.Powell_at_eds.com>
Date: 7 Jul 2004 06:51:53 -0700
Message-ID: <2687bb95.0407070551.65cbc8fc@posting.google.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 )
>
> > 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

How can you time test it? Get an SQLPlus window, set timing on, execute the query. Read elapsed time value. Repeat test several times. Average time.

Repeat entire process for other query.

Ideally you would run on a test system or during a maintenace window where you could bounce the instance just prior to starting a test run.

HTH -- Mark D Powell -- Received on Wed Jul 07 2004 - 08:51:53 CDT

Original text of this message

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