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>
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 QldReceived on Fri Jan 14 1994 - 02:20:57 CET