Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Shastryv
Posting Yak Master
145 Posts |
 Posted - 2001-06-28 : 12:32:03
|
| I need to execute a straightforward update which is taking too long time. Can any one tell me what are the things I need to look in to it Table contains around 3253572 rows.Statementupdate Table_NameSET TDate = 'mm/dd/yy'1) I checked the table fragmentation and dropped and recreated the clustered index2) Ran DBCC CHECKTABLE its very clear 3) No other process is using the table, only the update statement4) Index filfactor is 90Any comments are greatly appreciatedShastry.V |
|
|
|
|
|
Update Statement taking too long time