Re: optimal sql

From: <dev_at_null>
Date: Wed, 11 Dec 2002 14:21:51 +1100
Message-ID: <l32dvusij9j4as3b678gn8shs4nd3tmicg@4ax.com>

On Mon, 9 Dec 2002 13:12:35 +0100, "Peter van Rijn" <p.vanrijnREMOVE_at_THISzhew.nl> wrote:

> Christoph,
>
> It partly depends on how big your tables are. It may also depend on Oracle
> version.
> It is quite easy to test their effectiveness by just doing some testing
> yourself.
>
> Just use the autotrace facility:
>
> SQL> set autotrace traceonly explain
>
> and it will supply the execution plan for your queries, without really
> executing it.
>
> SQL> set autotrace off
>
> disables the facility.

I was under the distinct impression that autotrace always executed the query and the 'traceonly explain' only supressed the output.

A better solution for a long running query would be explain plan.

Anyone confirm / deny this?
>
> hth,
> Peter
>

Cheers

Steve Roach Received on Tue Dec 10 2002 - 21:21:51 CST