Home » RDBMS Server » Performance Tuning » Cost in the Explain Plan
Cost in the Explain Plan [message #216168] Thu, 25 January 2007 07:23 Go to next message
Messages: 194
Registered: January 2006
Senior Member
The general conception is that when the Cost is lower then execution is faster. I have 2 explain plans for the same SQL statement. One has more Cost than the other but runs faster. When does this happen?? Why??..
Re: Cost in the Explain Plan [message #216190 is a reply to message #216168] Thu, 25 January 2007 08:38 Go to previous messageGo to next message
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
Make sure you are looking at the "real" explain plan, the one that was actually run, not the one the optimizer thought it would run under a current environment. You can capture the "real" plan with a 10046 trace.

Re: Cost in the Explain Plan [message #216873 is a reply to message #216168] Tue, 30 January 2007 14:18 Go to previous message
Messages: 619
Registered: July 2006
Senior Member
There is only a week correlation between the cost and the actual execution time (IMHO - about 60-70%).
So the chances of getting query with higher run faster is quite big.

Previous Topic: users not logged on last 30 days
Next Topic: Which one best ?
Goto Forum:

Current Time: Sun Aug 20 23:50:42 CDT 2017

Total time taken to generate the page: 0.02416 seconds