Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2011

    Unanswered: What update its better

    I need to update a table with 7000000 of registers and currently I am taking data with a select from two table and then update a third table with this info, and I do this on a loop in order to make sure that I have all the registries on the third table updated. Is there any other wat to do this process faster.

    Thank you

  2. #2
    Join Date
    May 2005
    South Africa
    Provided Answers: 1
    write an update statement that is a join between the tables

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts