Source and target table compression specifications must match.
源表和目标表压缩规范必须匹配。
Table compression is on by default (if you purchase the option).
表压缩是默认启用的(如果您购买了该功能)。
Table compression on the other hand, was introduced in Oracle 9i release 2.
另一方面,表压缩是在Oracle9irelease 2中引入的。
Starting from setting up a corresponding mathematical model, a complete look-up table compression method is proposed.
从建立相应的数学模型入手,提出一种完备的表压缩方法。
The following example shows how to create partition table with compression.
下面的例子展示如何创建采用压缩的分区表。
Additionally, ADC only occurs if no compression dictionary exists within the physical table data object or partition.
此外,只有当物理表数据对象或分区中没有压缩字典时,才能运行adc。
If so, they still generate a compression dictionary, but in this case, there is no compressed record, as all data has already been moved into the table.
如果有,那么它们仍然生成一个压缩字典,但是在这里,没有被压缩的记录,因为所有数据已经被移到表中。
The above table and graph illustrate the theoretical savings of using dynamic compression.
上面的表和图给出的是动态压缩在理论上的性能结果。
Table 2 summarizes how the performance of this table scan query has benefited from two of our design decisions: atom site separation and compression.
表2总结了此次表扫描的性能如何能从我们的两个设计决策中受益:原子站点分离和压缩。
Patterns in the data: the frequency of recurring patterns in the data determines how effective compression will be for a particular table space or partition.
数据中的模式:对于特定的表空间或分区,数据中重复出现的模式的出现频率将决定压缩的效果。
It therefore depends on the table structure as to whether the row format of value compression has positive results.
因此,值压缩的行格式是否能产生正面的效果,取决于表的结构。
Note that each partition of a partitioned table can have a different compression dictionaries and each partition of a table in DPF can have a different compression dictionaries.
注意,分区表的每个分区可以有不同的压缩词典,在DPF中一个表的每个分区也可以有不同的压缩词典。
The premise behind ADC is to automatically create a representative compression dictionary based on sampling a small subset of table data.
ADC的前提是根据抽样的一小部分表数据自动创建一个代表性的压缩字典。
Reorganize the table to create a compression dictionary and compress the existing contents.Eg.
重组表来创建一个压缩字典然后压缩现有内容,例如。
Perform index reorganizations online and rebuild compression dictionaries when table reorganization takes place.
在线执行索引重组,并在发生表重组时重构压缩字典。
In DB2 9.1, the compression takes effect only after the table dictionary is built, which is usually during the table REORG phase.
在DB 2 9.1中,只有在建立了表字典之后(表字典通常是在表reorg阶段建立的),压缩才能生效。
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行压缩功能可以减少磁盘存储需求,同时改进执行全表扫描的大量查询的顺序读取访问。
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).
如果表是一个范围集群表(不支持行压缩),可以考虑将其变换为范围分区表(支持行压缩)。
Table size: Compression tends to work better for larger table Spaces.
表的长度:对于更大的表空间,压缩更为有效。
From DB2 version 9.5 the database can dynamically create the compression dictionary as data is loaded into the fact table.
对于DB 2 9.5,当数据被加载到事实表时,数据库可以自动创建压缩字典。
Alternatively, you can alter a table to enable compression, and then you can reorganize it to compress the data.
还可以为现有的表启用压缩,然后可以重组它以便压缩数据。
The statement returns the number of bytes for each table entry that are saved by using the value compression row format.
该语句返回使用值压缩行格式为每个表条目节省的字节数。
Whether or not space can be saved by using system default compression depends on the data in the table columns.
使用系统默认值压缩能否节省空间取决于表列中的数据。
By changing the table attribute VALUE COMPRESSION, you can determine in what row format new rows for a table are stored.
通过更改表属性VALUECOMPRESSION,可以决定按照什么行格式存储新的表行。
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列。
In conversions to DB2 9.1, the ALTER TABLE statement with data compression is supported, and limited support is provided for CREATE TABLE statement.
在到DB 2 9.1的转换中,包含数据压缩的ALTERtable语句是受支持的,CREATE table语句也受到有限的支持。
In DB2 9, the default compression dictionary directive for the REORG TABLE command is KEEPDICTIONARY.
在DB 29中,REORGTABLE命令中的默认压缩字典指令是KEEPDICTIONARY。
Before you execute the generated script reorg.sql, you need to create the ALTER TABLE statements to activate value compression.
在执行生成的reorg . sql脚本之前,需要创建ALTERtable语句,以激活值压缩。
The new table UDF and view for compression information
用于压缩信息的新的表UDF和视图
In addition, Deep Compression was used to compress both table and index data.
此外,DeepCompression则被用于压缩表和索引数据。
应用推荐