September 22, 2011 at 1:10 am
Hi all,
I am using 2 DB's one is in 2005 and other is in 2008 both are same only the sql server version is different.
i have a query which is consist of around 15 joins, is it possible that it will generate different execution plan for different version of sql server.
September 22, 2011 at 2:36 am
Not only is it possible, it's very likely unless the two servers are absolutely identical (SQL version, indexes, statistics, data size, data distribution)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 22, 2011 at 2:46 am
my problem is in 2005 server the same query is taking less time compare to 2008 server and the time difference is around 10 min. indexes are same in both, what would be the problem.
help is highly appreciated.
September 22, 2011 at 2:52 am
Please post table definitions, index definitions and execution plans, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply