Server A is more powerful than Server B has more everything (server B is
the back up for A)
I'm not sure about table statistics...
-----Original Message-----
From: Schlieper Paul
[mailto:mssqldba-ezmlmshield-x85874677.[Email address protected]
Sent: Friday, October 29, 2004 7:33 AM
To: LazyDBA Discussion
Subject: RE: SUSPECT: Union in Query Different execution plans
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]
---------------------------------------------------------------------
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