Posted by Nishant Saini on 12/16/06 11:35

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? Can we control the execution plans?

On Dec 16, 6:39 am, Roy Harvey <roy_har...@snet.net> wrote:
> On Fri, 15 Dec 2006 15:54:07 -0600, "Russ Rose" <russr...@hotmail.com>
> wrote:
>
> >Assuming identical hardware, a 10x speed difference is usually the
> >difference between memory and disk access.My experience, for what it is worth, has been that extreme performance
> differences - better or worse - are usually the result of different
> execution plans.
>
> Roy Harvey
> Beacon Falls, CT

If there are no indexed views in the database ans data is selected from
tables directly, then should there be any difference in performance?

>"Indexed views can be created in any edition of SQL Server 2005. In
>SQL Server 2005 Enterprise Edition, the query optimizer automatically
>considers the indexed view. To use an indexed view in all other
>editions, the NOEXPAND table hint must be used."

Thanks and regards,
Nishant Saini
http://www.simplyjava.com

[Back to original message]