Data Compression

Data compression can be configured for the following database objects:

• A whole table that is stored as a heap.
  
• A whole table that is stored as a clustered index.
  
• A whole nonclustered index.
  
• A whole indexed view.
  
• For partitioned tables and indexes, the compression option can be configured for each partition, and the various partitions of an object do not have to have the same compression setting.
  

More On :- More On :-