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.

Set index compression on:

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.