Home » SQL & PL/SQL » Client Tools » How to compare the two different explain plan in PL/SQL Developer (Oracle 11g)
How to compare the two different explain plan in PL/SQL Developer [message #602106] Fri, 29 November 2013 08:00 Go to next message
na.dharma@gmail.com
Messages: 62
Registered: May 2008
Location: bangalore
Member

Hi

How to compare the two different explain plan in PL/SQL Developer

Thanks
Dharma
Re: How to compare the two different explain plan in PL/SQL Developer [message #602107 is a reply to message #602106] Fri, 29 November 2013 08:01 Go to previous messageGo to next message
cookiemonster
Messages: 10914
Registered: September 2008
Location: Rainy Manchester
Senior Member
By looking at them.
What sort of comparison were you expecting?
Re: How to compare the two different explain plan in PL/SQL Developer [message #602127 is a reply to message #602106] Fri, 29 November 2013 13:19 Go to previous message
Lalit Kumar B
Messages: 2148
Registered: May 2013
Location: World Wide on the Web
Senior Member
As far as I know, PL/SQL Developer can only generate explain plan on pressing F5 for a given SQL. But to compare two explain plans you need to figure out your own way. Use examdiff software or any third party tool. However, you could understand the difference in the execution plans by analyzing them manually. That's the best way. At least for me.
Previous Topic: Suggestion for using sql developer
Next Topic: Format Code
Goto Forum:
  


Current Time: Thu Aug 28 02:11:41 CDT 2014

Total time taken to generate the page: 0.10697 seconds