How to Explain Plan in Toad?

Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.

April 26, 2023
Toad
1 min read

In Toad, it is effortless to execute Explain Plan for an SQL query and also very comfortable to read. Follow these steps to view Explain plan in Toad.

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;