499 total views, 11 views today

How to generate Explain plan in SQL Developer

Using Explain Plan, we can find the

  • Order of tables executed the given SQL
  • Index is executed or not
  • Join statement & Order
  • Cost & Cardinality

 

TO Generate Explain Plan

 

1. Open SQL Developer >> Open a database connection >> Write a SQL query and click on the Explain Plan or hit F10

 

052217_0236_1 How to generate Explain plan in SQL Developer

 

TO compare Explain Plan in SQL Developer

Click the PIN icon to save the explain plan,

 

052217_0236_2 How to generate Explain plan in SQL Developer

 

Run the explain plan again by hitting F10 or click on the Explain Plan;

 

052217_0236_3 How to generate Explain plan in SQL Developer

 

You will see the comparison

 

052217_0236_4 How to generate Explain plan in SQL Developer

 

Export the Explain plan in HTML in SQL Developer

 

We can export the explain plan as an HTML file. Right click on the explain plan and select Export HTML, Save it in a file

 

052217_0236_5 How to generate Explain plan in SQL Developer

The explain Plan in an HTML file

052217_0236_6 How to generate Explain plan in SQL Developer

govindan How to generate Explain plan in SQL Developer
Connect me

Govind

Thank you for visiting my personal blog. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life.

The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.

Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply šŸ™‚
govindan How to generate Explain plan in SQL Developer
Connect me
By | 2017-06-11T18:11:42+00:00 May 21st, 2017|Categories: Oracle|Tags: , |0 Comments
Like us on Facebook.
Connect!