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

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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: 13960
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.

Report message to a moderator

Previous Topic: Performance on single query
Next Topic: Simple select is not executed
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 05 15:43:19 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.