Re: explain plan from pl/sql ?

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Fri, 07 Nov 2003 19:27:02 +0000
Message-ID: <b2snqv8vegc7c8amg9f9d8sg0d3hrg8ve7@4ax.com>

On Fri, 07 Nov 2003 09:24:49 -0800, Daniel Morgan <damorgan_at_x.washington.edu> wrote:

>Oracle has already published statements that the DBMS_XPLAN built-in
>package should
>be used rather than Explain Plan. Why the discussion of something Oracle
>has advised be
>dropped?

Could you provide references to those statements? DBMS_XPLAN's DISPLAY function is very useful, but it's only for formatting the results of an EXPLAIN PLAN statement previously generated into a plan table. How can EXPLAIN PLAN be deprecated in favour of DBMS_XPLAN if there's no way of generating a plan with it?

--
Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)

Received on Fri Nov 07 2003 - 13:27:02 CST