EXPLAIN PLAN output; need sql script

From: Hans Plambeck <hans_at_iris.mincom.oz.au>
Date: 14 Jan 94 01:20:57 GMT
Message-ID: <6722_at_iris.mincom.oz.au>


Has anyone written some script to "encrypt" the output from

    plan_table rows.

I used the performance guide:

SELECT LPAD(' ',2*(LEVEL-1))||OPERATION||' '||OPTIONS||' '||OBJECT_NAME||' '||

            DECODE(ID, 0, 'Cost = '||POSITION) "Query Plan"
            FROM PLAN_TABLE
            CONNECT BY PRIOR ID = PARENT_ID;

But there could be something better.

-- 
-----------------------------------------------------------------------------
Hans-J Plambeck | hans_at_mincom.oz.au          | +61 (7) 364 9999, Fax 394 2844
Mincom Pty Ltd. | Juliette St. || P.O.Box 72 | Stones Corner 4120 Qld  
Received on Fri Jan 14 1994 - 02:20:57 CET

Original text of this message