What are Sparse Columns?

Posted by

To view Verified answers click on the button below.

A sparse column is another tool used to reduce the amount of physical storage used in a
database. They are the ordinary columns that have an optimized storage for null values.
Sparse columns reduce the space requirements for null values at the cost of more overhead
to retrieve nonnull values.