Configure Table Settings and Create Index Compressions

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

1. Right-click the table and select Advanced > Advanced Settings

   The Table Settings dialog is displayed.

   

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 grayed out until the "Enable physical valid table" option is selected.

   For more information about individual compression types, see 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.