Timeline for Why did my UPDATE statement not complete?
Current License: CC BY-SA 3.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 5, 2014 at 13:35 | history | edited | Colin 't Hart | CC BY-SA 3.0 |
deleted 8 characters in body; edited tags
|
| Jun 26, 2014 at 11:37 | comment | added | Xameer | most of the times when your WHERE clause is not fetching needed rows then the update does not works | |
| Aug 16, 2011 at 20:41 | history | edited | RolandoMySQLDBA | CC BY-SA 3.0 |
edited title
|
| Aug 16, 2011 at 20:26 | answer | added | bumble_bee_tuna | timeline score: 1 | |
| Jun 24, 2011 at 13:54 | comment | added | Gryphoenix | The rows are not deleted by this update statement. Only one field for each row is updated. | |
| Jun 24, 2011 at 13:53 | comment | added | Gryphoenix | The clustered index update, for the primary key, takes up a majority of the query cost at 65%. The other heavy hitters are 2 Table Spool (Eager Spool) at 24% | |
| Jun 23, 2011 at 15:10 | answer | added | MauMen | timeline score: 2 | |
| Jun 23, 2011 at 12:57 | comment | added | gbn | How many rows are deleted? Do you shrink your databases at all? | |
| Jun 23, 2011 at 11:30 | history | tweeted | twitter.com/#!/StackDBAs/status/83859547554455554 | ||
| Jun 22, 2011 at 21:15 | comment | added | Marian | @Gryphoenix Try to see if there are connections blocking your current transaction. Maybe you have already a long running transaction, or there is a transaction left open. You can find here some help about finding information regarding blocking/blocked processes. | |
| Jun 22, 2011 at 19:14 | comment | added | mrdenny | What's the wait information for the query? What's the execution plan look like? | |
| Jun 22, 2011 at 15:20 | comment | added | Gryphoenix | I have non-clustered indexes on the columns in the first update query that I tried to update 1 row from. I re-built all of the indexes but no change in execution. | |
| Jun 22, 2011 at 14:22 | comment | added | Jeff | What are the indexes you have on the tables in this job? | |
| Jun 22, 2011 at 14:11 | history | asked | Gryphoenix | CC BY-SA 3.0 |