Does updating a value in a row rewrite the whole row or just the value? I know this might be a stupid question, most likely it will just update the specific column, but I just wanted a confirmation
Loading
Does updating a value in a row rewrite the whole row or just the value? I know this might be a stupid question, most likely it will just update the specific column, but I just wanted a confirmation
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Sachin SinghPosted Jul 28, 2021, 10:35 AM
I don't know about other databases, but for the SQL server that works on pages, the whole page is rewritten.
The fundamental unit of data storage in SQL Server is the page. The disk space allocated to a data file (.mdf or .ndf) in a database is logically divided into pages numbered contiguously from 0 to n. Disk I/O operations are performed at the page level. That is, SQL Server reads or writes whole data pages.