Row compression was introduced in DB2 9.
行压缩是在DB 29中引入的。
Behavior changes in row compression using the offline reorg utility.
使用离线reorg实用程序的行压缩中的行为的变化。
The row compression feature was one of the most popular features in DB2 9.
行压缩特性是DB29中最流行的特性之一。
Besides, data row compression, other compression mechanisms offered by DB2 9.7 include.
除了数据行压缩，DB 2 9提供的其他压缩机制还包括。
Using the DB2cmd SQL tool, alter the AW fact tables noted in (a) to enable row compression.
使用DB 2 cmdSQL工具，改变(a)中标注的AW事实表来启动行压缩。
In addition to row compression, additional savings can be gained with value compression.
除了行压缩之外，通过数值压缩可以获得额外的存储空间。
DB2's row compression, unlike Oracle's key compression, does not require keys to be specified.
DB2的行压缩不像Oracle的键压缩，它不需要指定键。
DB2 row compression was designed to reduce disk storage space requirements of database objects.
DB 2行压缩被设计用来减少数据库对象的磁盘存储空间需求。
There are some differences in how row compression is implemented using DB2 version 9.1 and later versions.
如何实现行压缩在DB 2version 9.1和更高版本上有一些不同。
For more information, see the "2.4 Behavior changes in row compression using offline reorg utility" section.
欲了解更多信息，请参阅“2.4使用离线reorg实用程序的行压缩中的行为的变化”小节。
This document describes implementation of DB2 row compression in an Adaptive Warehouse generated data warehouse.
本文介绍了一个AdaptiveWarehouse生成的数据仓库中的 DB2行压缩（row compression）的实现。
You can achieve much better compression rates with row compression, but this feature requires a separate license.
通过行压缩可以获得更好的压缩率，但是该特性需要单独的许可。
Behavior changes in row compression for tables that have data rows less than or equal to the minimum record length.
对于数据行小于或等于最小记录长度的表的行压缩中的行为变化。
In DB2 9.5, the automatic dictionary creation feature is introduced to further enhance the row compression offering.
DB 2 Viper 2中引入了自动字典创建特性，以进一步增强行压缩。
This tutorial takes you through a series of exercises to familiarize you with this new dictionary-based row compression feature.
本教程通过一系列的练习让您熟悉这项新的基于字典的行压缩特性。
Following are DB2BATCH run sample summaries illustrating query execution times before and after row compression has been enabled.
以下是DB2BATCH运行样例摘要，说明启动行压缩之前和之后的查询执行时间。
Row compression requires the creation of a dictionary which stores a mapping between repetitive patterns or entries and numeric keys.
行压缩要求创建一个词典，它存储重复的模式或条目与数字键之间的映射。
Of the various data compression techniques available in DB2 9.7, row compression offers the biggest possibilities for storage savings.
在DB2 9.7提供的数据压缩技术中，行压缩在节省存储空间方面最为极端。
With the data returned, you can make a decision on whether you would like to perform an offline table reorg to take advantage of row compression.
利用返回的数据，可以决定是否执行离线table reorg，以利用行压缩。
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.
以下脚本可被编辑并在您的数据仓库数据库上运行，来生成一个脚本跨所有AW创建的事实表启动行压缩。
However, there is an added cost in implementing row compression as well as processing costs associated with every time a row must be compressed or decompressed.
不过，实现行压缩需要一定的附加成本，并且每当需要压缩或解压缩一个行时，都需要付出相应的处理成本。
DB2 row compression features can decrease disk storage requirements while at the same time improve sequential read access of large queries which perform full table scans.
DB 2行压缩功能可以减少磁盘存储需求，同时改进执行全表扫描的大量查询的顺序读取访问。
In DB2 9.7, row compression, also referred to as deep compression, compresses data rows by replacing patterns of values that repeat across rows with shorter symbol strings.
在DB 2 9.7中，行压缩(也称为深度压缩)通过把跨行重复出现的值模式替换为更短的符号字符串来压缩数据行。
If the table is a range clustered table (that does not support row compression), you can consider switching it to become a range partitioned table (that supports row compression).
如果表是一个范围集群表(不支持行压缩)，可以考虑将其变换为范围分区表(支持行压缩)。
In DB2 9, any data row that is equal to or less than the database manager minimum record length is not used in the sampling when building the dictionary, and is not compressed during row compression.
在DB 29中，在构建字典时，任何小于或等于数据库管理器最小记录长度的数据行都不用于抽样，并且在行压缩期间不会被压缩。
It therefore depends on the table structure as to whether the row format of value compression has positive results.
因此，值压缩的行格式是否能产生正面的效果，取决于表的结构。
It does this by creating a compression dictionary of symbols which replace repeating data patterns at the row level.
实现方法是创建一个压缩的符号字典，取代行级重复数据模式。
DB2 rows cannot span pages, and you may not achieve enough compression to fit more than one row on a page.
在DB 2中，行不能跨页，您可能无法实现足够的压缩来使一页可以容纳多行。
By changing the table attribute VALUE COMPRESSION, you can determine in what row format new rows for a table are stored.
通过更改表属性VALUECOMPRESSION，可以决定按照什么行格式存储新的表行。
Row Length: The larger the row is (especially as it approaches the size of a page), the less efficient compression might be.
行的长度： 行的长度越大（尤其是它接近页宽时），压缩的效率就越低。
应用推荐