When you design and code your applications, be aware of the differences that can cause deferred updates. Follow these guidelines to help avoid deferred updates:
Create at least one unique index on the table to encourage more direct updates.
Whenever possible, use nonkey columns in the where clause when updating a different key.
If you do not use null values in your columns, declare them as not null in your create table statement.
