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