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 |
|
ninel
Posting Yak Master
141 Posts |
 Posted - 2006-08-30 : 22:10:01
|
| I have a very large table (about 200,000 records), but there are only 2 fields in the table only one populated with data. I need to update the 2nd field with the first field's data.UPDATE Table1SET field2 = field1This is taking a really long time to run about 3.5 minutes.Is this normal? Can I create an index? What can I do to shorten the run time?Thanks,Ninel |
|
|
|
|
|
Should I use indexes?