April 23, 2014 at 7:48 am
Hi,
Does the execution plan various version to version in sql server 2008?
running the query in express edition it not showing missing index hint.
running the query in express edition showing missing index hint.
with different execution plan
will be there a difference in display of the execution plan in each of the edition(standard, enterprise, express and so on)
If so how to choose the execution plan based version
from version to version( like exp to dev and so on) the query execution will vary?
I know express edition will not have much details were as how about other editions like standard , personal,enterprise.
Correct me if i am wrong : Enterprise and Dev are same except the licensing
April 23, 2014 at 7:52 am
No, the optimiser's the same in all the editions. Express won't run queries in parallel (it's limited to one CPU) for example, standard has memory limits, etc.
The display of the plan is Management Studio, not the SQL engine.
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
April 23, 2014 at 12:20 pm
Differences in statistics are the more common explanation for differences in execution plans.
"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 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply