With nologging, if the system aborts, you simply re-run the 'update' again, as you have the original data in the main table. We institued the Insert into a dummy table append with nologging, and were able to complete the "update" in under 30 minutes. The cursor.For loop approach for the update was calculated to take 53.7 years to complete! One of our apps updates a table of several hundred million records. ![]() ![]() This is absolutely a viable approach, and one we have used repeatedly.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |