Posted by nitin.goel on 12/18/06 08:13

As Nishant said we are not using any special features of Enterprise
Edition. Indexed views are not being used and data is taken directly
from tables.

Regarding the execution plan, it may be different due to different
sizes of both databases. We are right now trying to check execution
plan for similar databases on both editions. We will post our findings
as soon as we get them.

Right now we need to know

1. Enterprise Edition has its own Query running mechanism ( which is
different and faster than Standard Edition mechanism) or NOT ?
2. If it is special, what kind of performance differences we will get
while using Std Edition.
3. Is there any specific DB size ( or table sizes ) for which Standard
Edition is fine and after that one should go for Enterprise.

Thanks in advance
Nitin Goyal


On Dec 16, 4:39 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Nishant Saini (nishant.sa...@gmail.com) writes:
> > Thanks for the responses...
>
> > Yes, The execution plans are different in both the databases.
> > Why the execution plans are so different in both the versions of SQL
> > Server 2005?There could be many reasons for that. Roy Harvey mentioned indexed views
> for instance.
>
> If you want a better answer, please post the query and the two plans,
> so that we know what we are talking about.
>
> > Can we control the execution plans?Yes. SQL 2005 actually permit you to specify the plan exactly to using
> plan guides. This is definitely an advance feature, and nothing you
> should use at a whim.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]