OraFAQ Forum: Performance Tuning » Different explain plan

Home » RDBMS Server » Performance Tuning » Different explain plan (Oracle 11g,Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Different explain plan [message #550886]

Fri, 13 April 2012 04:28

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

Littlefoot
Messages: 21765
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

Michel Cadot
Messages: 68455
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 09 22:59:47 CDT 2023