Originally posted by randy
Assuming I would be doing an update on a column (of a 2M rows table)
that is not indexed. Is it a good idea to always create indexes
on a column that would always be involved in an update?

Cheers,
Randy
If you are updating the whole table the index won't get used anyway. It will as tamilselvan implies, slow down the update, given that the index will need to be maintained.