The table COMPRESS attribute must be enabled in order for ADC to be applicable.
首先必须启用表属性COMPRESS,以便应用adc。
If neither keyword is specified, the KEEPDICTIONARY behavior will be used if the table COMPRESS attribute is turned on.
如果没有指定任何关键字,且表属性COMPRESS已启用,则使用KEEPDICTIONARY行为。
DB2 provides the capability to compress the data in a table space or partition.
DB 2提供了压缩一个表空间或分区中的数据的能力。
It can be used to compress entire tables, table partitions, and materialized views.
它可以用于压缩整个表、表分区和物化视图。
Reorganize the table to create a compression dictionary and compress the existing contents.Eg.
重组表来创建一个压缩字典然后压缩现有内容,例如。
This is accomplished by specifying the COMPRESS YES option in the CREATE TABLESPACE statement, and then executing either the LOAD or REORG utility on the table space.
这是通过在CREATEtablespace语句中指定COMPRESSYES选项,然后对表空间执行LOAD或REORG实用程序来实现的。
Note that the table does not require the COMPRESS attribute to be set to yes to use this capability.
注意,为了使用该功能,不需要将表属性compress设为yes。
Here are some things to consider when trying to decide whether or not to compress a table space or partition.
在决定是否压缩一个表空间或分区时,要考虑下面一些事情。
Alternatively, you can alter a table to enable compression, and then you can reorganize it to compress the data.
还可以为现有的表启用压缩,然后可以重组它以便压缩数据。
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.
在DB 2 9.7中,只需通过CREATEtable语句的COMPRESSyes子句启用XML数据的压缩功能,这会同时压缩表中的关系和xml列。
Since the sample table is defined with the option "compress yes", the relational data and the inlined XML documents get compressed.
由于示例表使用 "compressyes"选项进行了定义,因此将对关系数据和内联XML文档进行压缩。
Edit the generated SQL script adding the COMPRESS YES clause to the CREATE table statement for the noted fact tables.
编辑生成的sql脚本,对于标记的事实表添加COMPRESSyes子句到CREATEtable语句。
It's not uncommon to compress inlined XML data by 70 to 85 percent. The following statement can be used to check the compression ratio of the "product" table.
内联xML数据通常可以达到70%到80%的压缩比。
One way we can compress data is to use a frequency table or a frequency distribution.
压缩资料的一种有效方法是编制频率表或频率分布。
We have a table of the elements with properties varying periodically with atomic mass, so we compress all of that information and refer to it as the Periodic Table.
我们有一个元素表,其中的元素的特性,随着原子质量的改变而引起周期性的变化,所以我们将所有的信息精简,将它变成一个周期表。
Threshold and table are used to compress the inspecting data and store the defect codes of the tube.
采用阈值法和表格法压缩检测数据,并以代码形式贮存。
Threshold and table are used to compress the inspecting data and store the defect codes of the tube.
采用阈值法和表格法压缩检测数据,并以代码形式贮存。
应用推荐