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 |
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
 Posted - 2009-07-30 : 16:32:56
|
| We prepared an SQL recently to scrub production data in a non-prod. It is nothing but a bunch of update statements that update all the rows (may be 5 million)across 8 tables with dummy names , SSNs, addresses etc.But none of these fields are part of the indexes or Keys. Is it best to run the update statistics and Reindexing in this scenario? |
|
|
|
|
|
Regarding Update Statitics and ReIndexing