May 13, 2014 at 2:47 am
Hello Experts,
Can the estimated execution plan option give a rough estimate of how much time a query would take to complete and also in which part of the query the running time is high?
Thanks for your help
May 13, 2014 at 2:51 am
I think you've answered your own question.
An estimated execution plan gives a rough estimate.
Normally, the only difference between estimated and actual plans is that actual plans have the actual numbers populated.
May 13, 2014 at 2:55 am
There's nothing in an execution plan (estimated or actual) that reflects the time required to execute it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 13, 2014 at 5:42 am
In theory, the estimated values are a measure of the resources needed to execute a query. But they're just mathematical constructs with no actual relation to reality. Further, those constructs are the same on my systems as on yours. In other words, the speed of your disks or the power of your processors are not taken into account in these measures at all. So, as everyone else has already said, nope. No way to figure that out.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply