Indexes....Update !

[OLAPer]

Hi everyone !

I have a quick question regarding Index usage.

I am wanting to speed up an update, the columns that I am using to link the relevant tables are not indexed. I was wondering how the UPDATE command uses the INDEX created on a column?

Any assistance appreciated.

OLAPer

::->

 

[EdVassie]

If a column is used in an index and its value is changed, it will slow the update processing.
If a column is used in an index, and its value is NOT changed, it will have no impact on update processing. DB2 will not update a given index if the columns making up the index have not changed in value. This posting is a personal opinion only, and may not reflect reality.