Results 1 to 3 of 3

Thread: db2 update

  1. #1
    Join Date
    Apr 2004
    Posts
    190

    Unanswered: db2 update

    When db2 does an update, does it actually perform a delete and insert internally ?

    Thanks

  2. #2
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    no it doesn't
    Dave

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Only the index entries are deleted and inserted if the index value changes when the row is updated. That is because the index must be in the correct sequence at all times.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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