I have a weird issue that I just can't figure out. I have a query that runs on tables that are all located in db x. If I run the query under a different db (like use database y) then it runs in like 11 seconds. If I run the query under the db that all of the tables reside under (use database x) then it takes almost 4 minutes.
Why would it take so much longer to run under the db where all of the data/tables exists? Both dbs are on the same SQL 2005 server.
I just don't get it?
Any ideas?
S
We can't possibly give you a meaningful response without having more information. What is the query, what is the nature of the data, what is different between the two databases, etc.
Perhaps, using your description about, database X has data in it, and database Y does not?
|||If you think that execution plan will be same then why SQl statement take different time on different server. But have you checked the CPU Cost and I/O cost.
No comments:
Post a Comment