Home » Other » 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: 82
Registered: May 2008
Location: bangalore
Member
Hi

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

Thanks
Dharma

Report message to a moderator

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: 13904
Registered: September 2008
Location: Rainy Manchester
Senior Member
By looking at them.
What sort of comparison were you expecting?

Report message to a moderator

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: 3174
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.

Report message to a moderator

Previous Topic: Suggestion for using sql developer
Next Topic: Format Code
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Sep 30 01:57:02 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.