updating a primary key column

rashmi.ranjan75 · New User Joined: 20 Feb 2006 Posts: 34

Hi,

If i update a primary key column does it impact the performance of the sql. Any other constraint in updating primary key coulmn.

Please suggest.

Regards
rashmi

DavidatK · Posted: Tue Apr 25, 2006 5:39 am

rashmi,

Certainly updating the primary key, or any of the secondary keys is going to impact the performance of the SQL greater than updating non key columns. DB2 must also update the indexes for the keys you change.

Dave