Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    66

    Angry Unanswered: Delete-Insert over Update

    Hi All,

    I feel that Delete-Insert works faster than Update in case of millions of rows . If 100 millions of rows is to be updated then , better to use Delete-Insert instead of Update all the rows.

    But I don't have any practical experience regarding this . I couldn't find out any material also .
    Anyway , if anyone has any idea then plz let me know .
    Any suggestions will be appreciated.

    Thanks ..
    himridul

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Delete-Insert over Update


Posting Permissions

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