Explain plan table

delete from plan_table;

Explain Plan

set statement_id ='myid' For

select * from sf_task t inner join sf_user_task_item i on t.code = i.task_id;

select * from plan_table where statement_id = 'myid';

Select Lpad(' ',2*(Level -1)) || Level || '.' || Nvl(Position, 0) || ' '

|| Operation || ' ' || Options || ' ' || Object_Name || ' ' || Object_Type || ' ' ||

Decode(Id,0, Statement_Id || ' Cost = ' || Position, Cost) || ' ' || Object_Node "Query Plan"

From Plan_Table

Start With Id = 0 And Statement_Id ='myid'

Connect By Prior Id=Parent_Id

and statement_id = 'myid';

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7845854/viewspace-1056128/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7845854/viewspace-1056128/