> #### Compaction details for system tables

> Table 3–12 summarizes how the compaction process affects data rows contained in the specified tables.

> Table 3–12: System tables and the compaction process
> System table | What happens to table data during compaction
> --- | ---
> Sys_CPU | Averages will be stored.
> Sys_Dev | This is a multi-row table. The key to this table is Sample_ID and Device Name.
> Sys_Mem | Content reflects a mixing of compaction and averages.
> Sys_FileSize | This is a multi-row table in which averages are stored. The key to this table is Sample_ID and Name 2 additional fields—Max and Min.
> Sys_FileSys | This is a multi-row table in which averages are stored. The key to this table is Sample_ID and Mount.

Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095