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 |
|
sql.error1623
Starting Member
3 Posts |
 Posted - 2011-06-06 : 23:14:16
|
| HI All,I want to archive some of the data from tables in SQL server Management Studio.All that i need to do is Archive the data to another table,Drop the Indexes,Then delete the data from main table and Recreate the Index..!!Please Correct me if i am Wrong.If it is correct i wanted to know is Why we are dropping and recreating the index??Please help me..!!Thanks in Advance..!! |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2011-06-07 : 18:57:52
|
| If you were doing "large" inserts of data, there could be a performance boost from dropping the indexes before the insert and then re-creating the indexes afterwards. For your application, I would expect the dropped indexes to slow down the actual deletions since it would be are difficult to locate the records to delete. You might experiment with your data to see which way performs better for you.=======================================Elitism is the slur directed at merit by mediocrity. -Sydney J. Harris, journalist (1917-1986) |
 |
|
|
|
|
|
Archiving