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: 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?


Regards-
P

Report message to a moderator

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: 21823
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).

Report message to a moderator

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: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
And once again TOAD is misleading.
I wonder why people work with it...

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 26 14:17:29 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.