Home » RDBMS Server » Performance Tuning » Different explain plan (Oracle 11g,Linux)
Different explain plan [message #550886] Fri, 13 April 2012 04:28 Go to next message
Messages: 117
Registered: December 2007
Senior Member
Hi Team,
I required to tune one query which is running long.
When I ran the query from TOAD, the Cost is showing only 21 and the query completing within 12 secs.

Now when I ran the query from application it is taking 2 hours to complete.

Can anyone sugeest Am I missing any important steps and any suggestion why there is a difference in timings?


Re: Different explain plan [message #550887 is a reply to message #550886] Fri, 13 April 2012 04:35 Go to previous messageGo to next message
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
TOAD is most probably returning only the first "n" records (say, 500 or 1000, depending on your settings).
Re: Different explain plan [message #550898 is a reply to message #550886] Fri, 13 April 2012 06:23 Go to previous message
Michel Cadot
Messages: 68632
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And once again TOAD is misleading.
I wonder why people work with it...

Previous Topic: Partition Pruning Not happening!
Next Topic: database statistics
Goto Forum:

Current Time: Fri Apr 12 12:14:11 CDT 2024