表压缩是默认启用的(如果您购买了该功能)。
Table compression is on by default (if you purchase the option).
从建立相应的数学模型入手，提出一种完备的表压缩方法。
Starting from setting up a corresponding mathematical model, a complete look-up table compression method is proposed.
它使用一种有效的算法压缩仓库表并将它们存储在内存中。
It compresses warehouse tables with an efficient algorithm and stores them in memory.
下面的例子展示如何创建采用压缩的分区表。
The following example shows how to create partition table with compression.
此外，只有当物理表数据对象或分区中没有压缩字典时，才能运行adc。
Additionally, ADC only occurs if no compression dictionary exists within the physical table data object or partition.
以下脚本可被编辑并在您的数据仓库数据库上运行，来生成一个脚本跨所有AW创建的事实表启动行压缩。
The following script can be edited and run on your warehouse database to generate a script to enable row compression across all AW created fact tables.
上面的表和图给出的是动态压缩在理论上的性能结果。
The above table and graph illustrate the theoretical savings of using dynamic compression.
该加速器然后访问这些表而不压缩数据，所以您没有索引开销。
The accelerator then accesses these tables without uncompressing data, so you don't have index overhead.
DB 2提供了压缩一个表空间或分区中的数据的能力。
DB2 provides the capability to compress the data in a table space or partition.
所有添加到表中的后续数据将被压缩。
重组表来创建一个压缩字典然后压缩现有内容，例如。
Reorganize the table to create a compression dictionary and compress the existing contents.Eg.
DB 2 9.7不仅压缩行数据；它还可以压缩索引、日志文件、临时表、内联xML数据和大对象。
DB2 9.7 compresses more than just row data; it can also compress indexes, log files, temporary tables, inline XML data, and large objects.
两个表中的关键列不能被压缩。
在线执行索引重组，并在发生表重组时重构压缩字典。
Perform index reorganizations online and rebuild compression dictionaries when table reorganization takes place.
使用清单5中如下命令来压缩这两个表。
The following commands in Listing 5 were used to compress both tables.
它可以用于压缩整个表、表分区和物化视图。
It can be used to compress entire tables, table partitions, and materialized views.
还可以为现有的表启用压缩，然后可以重组它以便压缩数据。
Alternatively, you can alter a table to enable compression, and then you can reorganize it to compress the data.
对于DB 2 9.5，当数据被加载到事实表时，数据库可以自动创建压缩字典。
From DB2 version 9.5 the database can dynamically create the compression dictionary as data is loaded into the fact table.
该语句返回使用值压缩行格式为每个表条目节省的字节数。
The statement returns the number of bytes for each table entry that are saved by using the value compression row format.
但是，压缩表不允许添加或删除列。
A compressed table, however, does not allow adding or dropping of columns.
在DB 2 9.7中，只需通过CREATEtable语句的COMPRESSyes子句启用XML数据的压缩功能，这会同时压缩表中的关系和xml列。
In DB2 9.7, the compression capability for XML data is enabled simply through the compress YES clause of the CREATE table statement, which compresses both relational and XML columns in the table.
您可以禁用压缩cgtt表。
新的管理视图sysibmadm . ADMINTABCOMPRESSINFO返回关于一个数据库的所有模式中所有表的压缩信息的报告。
The new administrative view SYSIBMADM.ADMINTABCOMPRESSINFO returns a report of compression information for all tables in all schemas of a database.
对于数据行小于或等于最小记录长度的表的行压缩中的行为变化。
Behavior changes in row compression for tables that have data rows less than or equal to the minimum record length.
如果您在使用一个压缩ccd表，那么在处理delete操作时，现有的行将被更新，而ibmqrep_operation列将被设为‘d’。
If you are using a condensed CCD table, when processing a delete, the existing row is updated and the IBMQREP_OPERATION column is set to 'd'.
提示3：使用XML存储选项：内联、压缩或单独的表空间
Tip 3: Exploit storage options for XML: inlined, compressed, or a separate table space
下面是关于如何使用该U DF获得表rowcomp . MDC的压缩统计信息报告的例子？
Here is an example of how to use the UDF to obtain the compression statistics report for table rowcomp.mdc.
在决定是否压缩一个表空间或分区时，要考虑下面一些事情。
Here are some things to consider when trying to decide whether or not to compress a table space or partition.
如果在inspect工具中使用离线table reorg或rowcompestimate选项，则表中的数据将被完全压缩。
If you use the offline table reorg or rowcompestimate option in the inspect tool, data in the table is fully compressed.
使用DB 2 cmdSQL工具，改变(a)中标注的AW事实表来启动行压缩。
Using the DB2cmd SQL tool, alter the AW fact tables noted in (a) to enable row compression.
应用推荐