Manage Index Compression

Use the Create Table and Create Index wizards to set index compression. You can subsequently turn it on or off on the table, index, or local index property screens.

Any table, index, or local index partition can be designated for index compression, except system catalogs and work tables.

The value of compression is page-level compression, which compresses redundant information on a page by storing repeated values in a single place and uses a symbol on the data page to refer to them.

• Setting Index Compression on an Index
  Use the Create Index wizard to specify index compression on an index.
• Setting Index Compression on a Local Index Partition
  Use the Create Index wizard to specify index compression on a local index partition.
• Setting Index Compression on a Table
  Use the Create Index wizard to specify index compression on a table.