What are the steps needed to run the Explain Plan in Toad?
To see the explain plan for an SQL, please use the following steps:
- Open the Editor in Toad
- Type in and run the SQL
- Go to Editor | Explain Plan Current SQL (or click the Explain Plan ambulance button)
Then the Explain Plan details will appear in the 'Explain Plan' tab just underneath the editor window.
