title | description | ms.author | ms.date | ms.topic | author | ms.reviewer |
---|---|---|---|---|---|---|
CompressionType Property |
Specifies the compression type used. |
solsen |
05/14/2024 |
reference |
SusanneWindfeldPedersen |
solsen |
Version: Available or changed with runtime version 3.0.
Specifies the compression type used.
- Table
Value | Available or changed with | Description |
---|---|---|
Unspecified | runtime version 3.0 | Use the compression type that is specified externally on the table, for example, in SQL Server. |
None | runtime version 3.0 | Do not use compression on the table. |
Row | runtime version 3.0 | Compress the table on a row-level. |
Page | runtime version 3.0 | Compress the table on a page-level. This includes row, prefix, and dictionary compression. |
CompressionType = None|Page|Row|Unspecified;
Note
The TableType property must be Normal
. This property cannot be used on table extension objects.
With None
, Page
, and Row
, the [!INCLUDEprod_short] table synchronization process will make changes to table in SQL Server, overwriting the current compression setting in SQL Server, if any. Unspecified
lets you control data compression directly on SQL Server or by specifying a database default compression level using the Set-NAVTenant cmdlet with the -Compression
parameter set.
For information about compression types, see Data Compression.
The following code snippet sets page-level compression on table 50100.
table 50100 MyTable
{
TableType = Normal;
CompressionType = Page;
fields
{
...
Properties
Page object
Set-NAVTenant cmdlet
Start-NAVDataCompression cmdlet