| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Explain Plan Problem
This statement doesn't execute.
it write only the explain plan to the plan_table. Be sure you have
created it.
truncate table plan_table;
EXPLAIN PLAN
SET STATEMENT_ID = 'TEST'
FOR select ................;
SELECT LPAD(' ',2*(LEVEL-1))||operation||' '||options
||' '||object_name
||' '||DECODE(id, 0, 'Cost = '||position) "Query Plan"
FROM plan_table
START WITH id = 0 AND statement_id = 'TEST'
CONNECT BY PRIOR id = parent_id AND statement_id = 'TEST';
Parvinder Singh wrote:
> Hi all
>
> can anyone tell me how to get the total explain plan of the query
> without practically executing it ???
>
> Regards
> ~Parvinder
--
 |
 |