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

Home -> Community -> Usenet -> c.d.o.server -> time performance SQLPLUS VS SQL Worksheet

time performance SQLPLUS VS SQL Worksheet

From: orsano <orsano_at_inf.uniroma3.it>
Date: Wed, 29 Jul 1998 10:12:46 +0100
Message-ID: <35BEE78D.EC43EE92@inf.uniroma3.it> 





Hi.


Is there someone who can tell me why running sqllpus queries into SQL
Worksheet I've


faster time response than using a stored procedure (with the same query)



called into SQLPLUS?


May be SQLPLUS and SQL Worksheet use a different default Oracle
optimizer.



My Oracle version is 7.3.3.



Thanks




<><><><><><><><><><><><><><><>





Orsano Alessandro


e-mail: orsano_at_dia.uniroma3.it



<><><><><><><><><><><><><><><>









Received on Wed Jul 29 1998 - 04:12:46 CDT












Original text of this message













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