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: How to speed up my SQL commands?

Re: How to speed up my SQL commands?

From: Yvan Galas <yvan.galas_at_fr.adp.com>
Date: Fri, 28 Jan 2000 16:00:03 GMT
Message-ID: <3891BD18.706B19AB@fr.adp.com>


Manuel Dias wrote:
>
> I have performance problems with my SQL statments in my Oracle 8.1.5 db.
> Does any body knows where can I find the ORACLE SQL ANALYSE
> tool (or similar) to help me improve my SQL statments?
>
> Thank you!
> Manuel Dias

Hi,

The only way to do that It's think about your sql order (How the parser works and the amount of data that you manipulate), you can use EXPLAIN PLAN too...

Cause more you learn without any tools, more you're efficient...

Zoil. Received on Fri Jan 28 2000 - 10:00:03 CST

Original text of this message

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