Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Oracle Execution Plan

I am using Oracle 11g and Toad for Oracle. How can I display execution plan for queries? In Sql server management studio execution plan can be displayed as graphical format. Is there any functionality/tool like that on Toad for oracle?

like image 678
Umut Derbentoğlu Avatar asked Feb 13 '12 22:02

Umut Derbentoğlu


1 Answers

CTRL-E

Make sure you've ended the query with a semi-colon (and the query above)

Edit:

You need to set-up the TOAD plan table for use. If you think it's already setup on your DB then you may just need to be granted access. Alternatively in my slightly older version of TOAD it's under:

Database --> Administer --> Server Side Objects Wizard. From here you can create the plan table(s) in a schema that you choose.

like image 64
cagcowboy Avatar answered Nov 09 '22 23:11

cagcowboy