On Monday, June 15, 2015, Bianca Stephani <
bianca.stephani@gmail.com> wrote:
Hi everyone.
I want to update the value of a column of 25 thousand rows and a sql update is taking forever (literally, more then one day). There's any other way so i can do that?
This would normally takes seconds (at most) if everything is working properly, so yes. I would suspect your where clause is not using an index to find those rows and there are a lot more than 25k rows on the table in question. Show us schemas and explain output if you want a more definitive answer.
Or you have locking issue...
David J.