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: tojo <Tojo_at_hotmail.com>
Date: Wed, 7 Jul 2004 09:13:13 +0200
Message-ID: <MPG.1b55c0f5120d6dab9896f2@news.t-online.de>


In article <2l1dfuF7cgu4U1_at_uni-berlin.de>, f93c0532_at_yahoo.com says...
>
> How can I test for speed? I'm using Toad 7.6
>

>
>

Write a PL/SQL block that generates 100000 random strings, some of which should end with ">>". Write one version that uses LIKE for the compare, another version using SUBSTR. Turn on SQL*Plus timing and compare.

Received on Wed Jul 07 2004 - 02:13:13 CDT

Original text of this message

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