• Article

Data Compression Wizard (Select Compression Type Page)

Use the Select Compression Type page to choose a type of compression for the table or index. Available types are row compression, page compression, and none (indicating no compression). If the table or index is partitioned, the table will list all partitions. If the table or index is not partitioned, the table will list partition number 1. To estimate the space, click Calculate

  • Use the same compression type for all partitions
    Select to configure the same compression setting for all partitions. This enables the selection box and disables the CompressionType column in the grid.

  • Partition Number.
    Lists each partition in the table or index. This column is read-only.

  • Compression Type
    Select the compression option for each partition. Is not available when Use the same compression type for all partitions is selected.

  • Boundary
    Displays the partition boundary. This column is read-only.

  • Row Count
    Displays the number of rows in this partition. This column is read-only.

  • Current Space
    Displays the current space this partition occupies in megabytes (MB). This column is read-only.

  • Requested Compressed Space
    After you click Calculate, this column displays the estimated size of each partition after compression by using the setting specified in the Compression Type column. This column is read-only.

  • Calculate
    Click to estimate the size of each partition after compression by using the setting specified in the Compression Type column.