What are Sparse Columns?

What are Sparse Columns?

A sparse column is basically a tool of the data base which is use for the decrease physical storage amount which is used in a database.Sparse columns also be use for the reducing work Its reduce the space requirements for null values at the cost of more overhead to retrieve no null values. They are the normal 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 no null values.

By:UMANG
Date:2012-01-09 00:00:00

Post Your Answers


User Email:

User Name:
Answers:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher