As far as i know, the lowest level locking is row-level
However i don't see the reason why it can not have column level locking
Assume that 2 queries simultaneously updates 2 different columns.
So why it can not happen? Why each update has to lock at least row level?
This behavior tells me that i should split table into smaller tables so less row level locking would happen
Am i incorrect?