Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: no exec
I think he wants something like SET AUTOTRACE TRACEONLY EXPLAIN. Once you have the EXPLAIN appended, you get the execution plan without actually executing the query, just like you EXPLAIN PLAN FOR... followed by SELECT ... FROM PLAN_TABLE..CONNECT BY. The only annoyance is that the output after you SET AUTOTRACE TRACEONLY EXPLAIN is always 70 characters wide even if you SET LINESIZE to a big number.
Yong Huang
yong321_at_yahoo.com
Thomas Kyte <tkyte_at_us.oracle.com> wrote in message news:<62ofhtgbcvts3bn0eaekbn82noj18vhmbp_at_4ax.com>...
>
> explain plan will tell you want a query does without doing the query.
>
> http://technet.oracle.com/doc/oracle8i_816/server.816/a76989/ch4i30.htm#4212
>
> the traceonly of autotrace actually executes the query and fetches all of the
> rows -- it just doesn't print them out. It shows you what the query will do in
> real life without taking the time to scroll the screen....
Received on Sat Jun 02 2001 - 00:13:19 CDT