Posted by Erland Sommarskog on 12/18/06 22:14

(nitin.goel@daffodildb.com) writes:
> 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.

If you want to compare Standard and Enterprise, you must of course
use the same database on the same hardware. Else the test is meaningless.

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

Rather than asking questions on the net, and hope that people will look
up the answers for you, why not look in this place in Books Online
instead:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/81f3e917-884a-4cc8-aca2-0a5fea89f355.htm

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]