行压缩是在DB 29中引入的。
与值压缩相比，行压缩能节省更多的存储空间。
The storage savings are greater than the savings provided with value compression.
行压缩特性是DB29中最流行的特性之一。
The row compression feature was one of the most popular features in DB2 9.
DB 2行压缩被设计用来减少数据库对象的磁盘存储空间需求。
DB2 row compression was designed to reduce disk storage space requirements of database objects.
使用离线reorg实用程序的行压缩中的行为的变化。
Behavior changes in row compression using the offline reorg utility.
本教程通过一系列的练习让您熟悉这项新的基于字典的行压缩特性。
This tutorial takes you through a series of exercises to familiarize you with this new dictionary-based row compression feature.
除了数据行压缩，DB 2 9提供的其他压缩机制还包括。
Besides, data row compression, other compression mechanisms offered by DB2 9.7 include.
除了行压缩之外，通过数值压缩可以获得额外的存储空间。
In addition to row compression, additional savings can be gained with value compression.
行压缩要求创建一个词典，它存储重复的模式或条目与数字键之间的映射。
Row compression requires the creation of a dictionary which stores a mapping between repetitive patterns or entries and numeric keys.
DB2的行压缩不像Oracle的键压缩，它不需要指定键。
DB2's row compression, unlike Oracle's key compression, does not require keys to be specified.
通过行压缩可以获得更好的压缩率，但是该特性需要单独的许可。
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.
使用DB 2 cmdSQL工具，改变(a)中标注的AW事实表来启动行压缩。
Using the DB2cmd SQL tool, alter the AW fact tables noted in (a) to enable row compression.
利用返回的数据，可以决定是否执行离线table reorg，以利用行压缩。
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.
以下是DB2BATCH运行样例摘要，说明启动行压缩之前和之后的查询执行时间。
Following are DB2BATCH run sample summaries illustrating query execution times before and after row compression has been enabled.
在DB2 9.7 提供的数据压缩技术中，行压缩在节省存储空间方面最为极端。
Of the various data compression techniques available in DB2 9.7, row compression offers the biggest possibilities for storage savings.
如果表是一个范围集群表(不支持行压缩)，可以考虑将其变换为范围分区表(支持行压缩)。
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).
DB 2行压缩功能可以减少磁盘存储需求，同时改进执行全表扫描的大量查询的顺序读取访问。
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.
欲了解更多信息，请参阅“2.4使用离线reorg实用程序的行压缩中的行为的变化”小节。
For more information, see the "2.4 Behavior changes in row compression using offline reorg utility" section.
以下脚本可被编辑并在您的数据仓库数据库上运行，来生成一个脚本跨所有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.
占用的存储空间少于32kb的小型XML文档可以与关系数据一起内联存储在同一行中，可以对整行进行压缩。
Small XML documents that occupy less than 32kb of storage space can be inlined with any relational data present in the same row, and the entire row can be compressed.
要执行压缩所有行所需的reorg，可以执行用vc_reorg . sql生成的reorg . sql脚本。
To perform the REORGs that are required to compress all rows, execute the reorg.sql script generated with vc_reorg.sql.
在DB 2 9.7中，行压缩(也称为深度压缩)通过把跨行重复出现的值模式替换为更短的符号字符串来压缩数据行。
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.
本文介绍了一个AdaptiveWarehouse生成的数据仓库中的 DB2行压缩（row compression）的实现。
This document describes implementation of DB2 row compression in an Adaptive Warehouse generated data warehouse.
行模式很适合那些复制或压缩大型文件集的系统管理脚本。
Line mode is ideal for systems administration scripts that copy or compress large collections of files.
因此，值压缩的行格式是否能产生正面的效果，取决于表的结构。
It therefore depends on the table structure as to whether the row format of value compression has positive results.
压缩算法足够智能，不会压缩那些对节省磁盘空间帮助不大的行。
The compression algorithm is intelligent enough not to compress rows that will not realize in any significant disk-space saving.
三个StorageOptimization组件中最重要的是压缩，它分析数据库中的每一行，寻找重复出现的数据模式。
The first of the three Storage Optimization components is compression, which examines each row in the database for recurring patterns of data.
可以使用下面清单1中的sql语句来确定，通过设置表属性VALUECOMPRESSION，是否可以因使用值压缩的行格式而节省表的空间。
You can use the SQL statement in Listing 1 below to determine whether setting the table attribute value compression will save space for a table concerned by using the row format of value compression.
exe压缩myisam表在创建表的语句中使用VALUECOMPRESSION，可以在列或表级别上使用节省空间的行格式来减少空间占用。
Myisampack.exe Compresses myisam table use VALUE COMPRESSION in create table statement to use the space saving row format at the column or table level to reduce space required for a table.
应用推荐