Hello
I am using SQL server 2000
I have a piece of code that performs a large amount of updates against every row on a table
The code runs in about a couple of minutes against 5 of my 6 databases
The other one takes over an hour
All 6 databases are sychronised (Using SQL compare), such that the indexes etc. are identical
When I look into the execution plan, it's creating a Sort/Distinct step that looks to be the source of the problem
How does this happen with an update
There is no grouping in my code. Just a number of left outer joins to ensure onene updates
Does anybody have any thoughts?
I've looked on a few sites and can't find any guidance
Thanks
Damian.
I am using SQL server 2000
I have a piece of code that performs a large amount of updates against every row on a table
The code runs in about a couple of minutes against 5 of my 6 databases
The other one takes over an hour
All 6 databases are sychronised (Using SQL compare), such that the indexes etc. are identical
When I look into the execution plan, it's creating a Sort/Distinct step that looks to be the source of the problem
How does this happen with an update
There is no grouping in my code. Just a number of left outer joins to ensure onene updates
Does anybody have any thoughts?
I've looked on a few sites and can't find any guidance
Thanks
Damian.