Alex Rivera | Logout

How much memory will be occupied by a null value in a DB?

Asked 2011-05-03T04:39:43.883
10

I was wondering how much memory does a null value occupy in a database can anyone answer clearly?

Edit
Report

1 Answer

5

How much space it takes up depends on what the column is defined to be and on the storage engine being used. Some data types take a fixed amount of space regardless of the data stored. There is a small space penalty for declaring a column to accept NULL. Details can be found in this general discussion in the manual and more in the docs about each storage engine.

answered 2011-05-03T04:57:18.553

Your Answer