SQL compression supported (4300647)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

SQL compression supported
Description

DBA would like to enable SQL data compression on several tables in ChangeAuditor archive databases.

Example syntax: ALTER TABLE Event REBUILD WITH (DATA_COMPRESSION = PAGE);
Resolution

Compression has not been tested with Change Auditor. It should work on the archive database as events aren't continually being added. After 5.9, it is recommended not to modify the databases and archiving was deprecated unless created by the Migration tool.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title