Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-31 : 10:26:21
|
| Dominic writes "I develop on my laptop and then copy things to a server in the office. I have a stored procedure which I have got working on my own sql server, it takes around 20 seconds the first time and then around 5 seconds after that. I have an exact copy of the database and sp on the server, with the same indexes and the sp takes around 25 seconds to execute every time. I am looking at the estimated execution plan for each in query analyzer and the one on the server is doing loads more work sorting records and building hash tables. I can't understand why they should be different and what I can do about it! Any advice would be gratefuly received.ThanksDominicps Laptop is Windows 2000 Pro SQL Server Desktop 7 sp3Server is Windows 2000 Server SQL Server Standard 7 sp3" |
|
|
|
|
|
Estimated Execution Plans