Home » RDBMS Server » Performance Tuning » explain plan difference between 9i and 10g (oracle 9i,oracle 10g)
explain plan difference between 9i and 10g [message #427871] Mon, 26 October 2009 04:53 Go to next message
manoj12
Messages: 185
Registered: March 2008
Location: India
Senior Member
Dear Sir

Why there is difference in the execution plan(explain plan) of Oracle 9i and Oracle 10g?.What is the reason to it.?

Appreciate your help on the above.?

Regards
Thakur
Re: explain plan difference between 9i and 10g [message #427878 is a reply to message #427871] Mon, 26 October 2009 05:06 Go to previous messageGo to next message
Michel Cadot
Messages: 63802
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you think you are the first to ask this question?
What did you search? What did you find? Why there are not answering your question?

Regards
Michel
Re: explain plan difference between 9i and 10g [message #427879 is a reply to message #427871] Mon, 26 October 2009 05:07 Go to previous message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
Changes to the way the optimiser works?
Different stats?
Different data?

If you have a specific problem post the query and explain plans - in code tags.
Previous Topic: Performance on single query
Next Topic: Simple select is not executed
Goto Forum:
  


Current Time: Sun Sep 25 23:13:07 CDT 2016

Total time taken to generate the page: 0.07857 seconds