| Author |
Topic |
|
Ghanta
Yak Posting Veteran
96 Posts |
 Posted - 2011-06-13 : 15:31:22
|
| Hi Guys,I am using a table with around 50 million records to update a table with 5 billion records. I have the appropriate indexes created on both these tables. I am doing the Updates in Batches of 1000 records. Is there a faster way to do this update? I cannot do Select INTO..Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Ghanta
Yak Posting Veteran
96 Posts |
Posted - 2011-06-13 : 15:38:33
|
| Thanks Tkizer so if no one else need to log into the table and we have enough space for log file... doing in one go should save lot of time correct? Unless there are other isseus and it needs to be rolled back... |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Ghanta
Yak Posting Veteran
96 Posts |
Posted - 2011-06-13 : 15:46:34
|
| Thank you tkizer. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Ghanta
Yak Posting Veteran
96 Posts |
Posted - 2011-06-13 : 16:27:21
|
| One more thing... doing the update in monthly batches (using a date field) or doing in same size batches using TOP () will have same effect rite? Thanks! Just wanted to check. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Ghanta
Yak Posting Veteran
96 Posts |
Posted - 2011-06-13 : 16:40:37
|
| Around same time to do the update? Right now I am only worried about time as log is fine and no one will use this table till tomm.. Thanks! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Ghanta
Yak Posting Veteran
96 Posts |
Posted - 2011-06-13 : 16:44:45
|
| You are rite. Thank you for your help. |
|
|
|
|
Updating 50 million records from 5 billion