Toad World® Forums

Using the explain plan question?

Hi all
I'm having problems getting on to the TOAD.
I using version 11.5, call the explain plan then I can't find the cost in the result.
What should I do ?

Thanks!
Nick

Right click on the Explain Plan and select Adjust Content. Check whether the Cost has been ticked and whether it is selected to be shown as a column.

Thanks for your reply, but I am follow you said the setting but it’s not working.
Nick
1.png

How about some of the other settings, like DBMS_XPLAN (under Display Mode). Do you still see no Cost value.

Dear Sir
I am set to Display mode->DBMS_XPlan not found the cost in there.

Thanks!
Nick

Hi All
Anybody can help me with the problem ?
Thanks
Nick

Hi all,

I have been fix the problem.
using the below:
select /*+ ALL_ROWS */ * FROM APP_USERS

Thanks!