Sign Up for Training |
insightsoftware Company Site
Submit a Request
Become a Jet Insider
Give Feedback

Table and Index Compression Control


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


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

    The Table Settings dialog will open.


  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.
Was this article helpful?
0 out of 0 found this helpful