Overview
The Jet Data Manager allows one to control table compression for an individual table and its indexes.
Process
-
Right click the table → Advanced → Advanced Settings.
The Table Settings dialog will open.
-
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
-
If desired, choose Compress Indexes. If checked, the Jet Data Manager will apply compression to indexes on the table as well.
Comments