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
pokhraj_d
Messages: 116
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?


Regards-
P

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
Littlefoot
Messages: 18828
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: 57612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And once again TOAD is misleading.
I wonder why people work with it...

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


Current Time: Sat Apr 19 05:44:09 CDT 2014

Total time taken to generate the page: 0.05857 seconds