Re: SQL optimisation

From: damorgan <damorgan_at_exesolutions.com>
Date: Wed, 27 Nov 2002 18:43:04 GMT
Message-ID: <3DE51236.C0D42075@exesolutions.com>

Monty wrote:

> Excuse me all but I am writing/optimising considerable amounts of SQL
> written for Oracle 7 to be deployed on an Oracle 9 database. Some of
> the queries are very complex and verbose, > 900-100 characters.
>
> Might I ask the opinions of the forum as to what applications are
> there out there that could be used to analyse existing queries and
> propose alternate and more efficient constructs.
>
> Thank you
> Monty.

My preference is still SQL*Plus with EXPLAIN PLAN and TKPROF.

Others may make it prettier. None do it better.

Daniel Morgan Received on Wed Nov 27 2002 - 12:43:04 CST