Like other operations on heap tables, an update on a table that has no useful index on the columns in the where clause performs a table scan to locate the rows to be changed.
