Wednesday, March 28, 2012

How to force 'lazy spool'

Hi,
I've got 2 server. One is the restore of the other.
But query where not performed by the same way on each.
One use a lazy spool, and the other does not.
The first make 2s to answer the query
The second make 4min !
I'd like to anderstand why !
It's the same installation of SQL Server 2000
And database are restore from each other.
Did anyone have an explication ?
ThanksHi
update statistics on both servers (for details please refer to the BOL)
"Florimond" <florimond@.gmail.com> wrote in message
news:ee293729.0504270647.7322ed74@.posting.google.com...
> Hi,
> I've got 2 server. One is the restore of the other.
> But query where not performed by the same way on each.
> One use a lazy spool, and the other does not.
> The first make 2s to answer the query
> The second make 4min !
> I'd like to anderstand why !
> It's the same installation of SQL Server 2000
> And database are restore from each other.
> Did anyone have an explication ?
> Thanks

No comments:

Post a Comment