when you run ...

select * from table
where columna is null
for update of columna

... how many of the 8 million rows generally match "columna is null"?

Do you never ever select, insert, update, delete at all apart from this?