In Toad, Open SQL editor by clicking on the menu Database > SQL Editor.
Then type your SQL query and press Ctrl+E to execute Explain Plan for that query.
If Plan Table does not exist in your database, then Toad will ask you to create a Plan Table. Click on OK button to create, if Plan table does not exist in your database.
After that you will see the result below in Explain Plan window as shown in below example:
SQL Query Example
SELECT e.first_name,
e.last_name,
d.department_name,
l.street_address,
c.country_name
FROM employees e,
departments d,
locations l,
countries c
WHERE e.department_id = d.department_id
AND e.manager_id = d.manager_id
AND d.location_id = l.location_id
AND l.country_id = c.country_id;
Explain Plan For an SQL Query in Toad For Oracle
In Toad, Open SQL editor by clicking on the menu Database > SQL Editor.
Then type your SQL query and press Ctrl+E to execute Explain Plan for that query.
If Plan Table does not exist in your database, then Toad will ask you to create a Plan Table. Click on OK button to create, if Plan table does not exist in your database.
After that you will see the result below in Explain Plan window as shown in below example:
SQL Query Example
SELECT e.first_name, e.last_name, d.department_name, l.street_address, c.country_name FROM employees e, departments d, locations l, countries c WHERE e.department_id = d.department_id AND e.manager_id = d.manager_id AND d.location_id = l.location_id AND l.country_id = c.country_id;Toad Explain Plan Example Result