WHAT ARE SPARSE COLUMNS IN SQL?

Sumit Kesarwani

Total Post:782

Points:3910
Posted by  Sumit Kesarwani
 1021  View(s)
Ratings:
Rate this:
  1. Sumit Kesarwani

    Post:782

    Points:3910
    What are Sparse Columns in SQL?

    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.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!