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]






MS Sql Server LazyDBA home page