How do I obtain a Query Execution Plan in Oracle IDEs?

user_12958319 0
Viewed 147

In Oracle IDEs, such as Navigator, Toad, Oracle SqlDeveloper how can I get a query execution plan for a query / stored procedure?

I can find some commands for them online, even though I am not able to use them sometimes, but is there any functionality/tools built-in for these IDE's for that purpose?

toad sql-execution-plan oracle sql
2 Answers

Here's for TOAD and SQL Developer; don't know about other tools as I don't use them.

user_90979060

Here are the ones I have found.

For navigator:

At the right-left corner

Or from Tools-Explain Plan Tolls

enter image description here

And I found out another tool for getting SQL Plan too. It has been of great help to me. It's

Dell™ SQL Optimizer for Oracle®

There, you can simply write your query, and it will both find better versions of it and show and compare their plans too.

enter image description here

user_129583190
Related