Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Table and Index Compression Control

Overview

The Jet Data Manager allows one to control table compression for an individual table and its indexes.

Process

  1. Right click the table → Advanced → Advanced Settings .

    The Table Settings dialog will open.

    mceclip0.png

  2. You can create compression on the Raw (_R), Valid (_V), or both variants of the table. You can create the following types of compression for either variant.

    • None for no compression
    • Row for row level compression
    • Page for page level compression

    The Valid table compression options will be greyed out until the "Enable physical valid table" option is selected.

    You can read more about individual compression types here: Index Compression Types

  3. If desired, choose Compress Indexes .  If checked, the Jet Data Manager will apply compression to indexes on the table as well.

Published:

Table and Index Compression Control

Overview

The Jet Data Manager allows one to control table compression for an individual table and its indexes.

Process

  1. Right click the table → Advanced → Advanced Settings .

    The Table Settings dialog will open.

    mceclip0.png

  2. You can create compression on the Raw (_R), Valid (_V), or both variants of the table. You can create the following types of compression for either variant.

    • None for no compression
    • Row for row level compression
    • Page for page level compression

    The Valid table compression options will be greyed out until the "Enable physical valid table" option is selected.

    You can read more about individual compression types here: Index Compression Types

  3. If desired, choose Compress Indexes .  If checked, the Jet Data Manager will apply compression to indexes on the table as well.

For an optimal Community experience, Please view on Desktop