Data Compression Wizard (Welcome Page)

Use the Data Compression Wizard to change the data compression settings for both tables and indexes. The Data CompressionWizard can also estimate the space that would be used by the table or index for each compression setting.

Compression can be configured for the following structures:

• 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.

For information about how to compress a table or index, see Creating Compressed Tables and Indexes.

The Welcome page is the first page of the Data Compression Wizard. Displaying this page is optional.