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