Toad World® Forums

EXPLAIN and running an EXPLAIN


#1

How come when I go to try and run an EXPLAIN and hit the “generate” button nothing happens???

Is this a permission issue???

Can someone clarify what permissions I need to run an EXPLAIN???

Thanks in advance for your help and review.

PSULionRP


#2

If I understand correctly, you select some code in the code editor, and then do “Tools->Explain Plan Tool” from the menu (or click the “Explain Plan” icon in the toolbar). Normally, you should already get an explain plan in the bottom pane (see first screenshot above).

If there’s something that prevents the explain plan tool to perform its duties, there normally is an error message somewhere to be found (for an example, see second screenshot above).

The “Generate” button is just there to click when you edit the SQL statement directly in the top pane (no need to return to the code editor, edit there, and restart the explain plan tool).
Bx_01.png


#3

If I understand correctly, you select some code in the code editor, and then do “Tools->Explain Plan Tool” from the menu (or click the “Explain Plan” icon in the toolbar). Normally, you should already get an explain plan in the bottom pane (see first screenshot above).

If there’s something that prevents the explain plan tool to perform its duties, there normally is an error message somewhere to be found (for an example, see second screenshot above).

The “Generate” button is just there to click when you edit the SQL statement directly in the top pane (no need to return to the code editor, edit there, and restart the explain plan tool).
Bx_02.png


#4

Hi,

Did you see any error? If it’s a permission issue, this link should help.

http://www.itk.ilstu.edu/docs/Oracle/server.101/b10759/statements_9010.htm

Cheers,
Gwen