CODEWITHSUNDEEP
sqloracle-databasesql-execution-plantoad
Isi
Isi

Reputation: 123

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

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?

Upvotes: 2

Views: 960

Answers (2)

Isi
Isi

Reputation: 123

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

Upvotes: 0

Littlefoot
Littlefoot

Reputation: 143083

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

Upvotes: 4

Related Questions