What are Sparse Columns in SQL?

Question

Sumit Kesarwani · Answer

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.

interview

What are Sparse Columns in SQL?

Sumit Kesarwani

Can you answer this question?

1 Answers

Liked By