Is the hardware indentical? RAM?
Table statistics?

-----Original Message-----
From: Nam Nguyen
[mailto:mssqldba-ezmlmshield-x34744372.[Email address protected]
Sent: Thursday, October 28, 2004 12:02 PM
To: LazyDBA Discussion
Subject: SUSPECT: Union in Query Different execution plans


Hi,

I have a query which contains a union and it runs incredibly slow on server
A 2-3 minutes,
however when I run it on server B which should be identical it takes only
6-10 seconds


I checked the Execution plan on both servers and the Execution plan for
server B has an addition step which I assume is making it faster
it's an Index Spool/Eager Spool step.

Would like to know how to make server A perform this step.

Thanks a ton

Nam Nguyen





---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]







---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]



MS Sql Server LazyDBA home page