Oracle Execution Plan

Question

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?

Answer 1

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.