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.
如果有,那么它们仍然生成一个压缩字典,但是在这里,没有被压缩的记录,因为所有数据已经被移到表中。
Additionally, ADC only occurs if no compression dictionary exists within the physical table data object or partition.
此外,只有当物理表数据对象或分区中没有压缩字典时,才能运行adc。
The premise behind ADC is to automatically create a representative compression dictionary based on sampling a small subset of table data.
ADC的前提是根据抽样的一小部分表数据自动创建一个代表性的压缩字典。
Therefore, REORG usually produces a dictionary that is more representative of the data in the entire table space or partition.
因此,REORG常常可以产生更能代表整个表空间或分区中的数据的字典。
Before putting replication data into the send queue, the source server first converts the data from the local table dictionary format to the master replicate dictionary format.
在将复制数据放入到发送队列之前,源服务器首先将数据从本地表字典格式转换为主复制字典格式。
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,当数据被加载到事实表时,数据库可以自动创建压缩字典。
Similarly, before applying replication data, a target server first converts replication data that is in mastered dictionary format to the local table dictionary format.
类似地,在应用复制数据之前,目标服务器首先将主字典格式的复制数据转换为本地表字典格式。
The target server converts the row data from the master dictionary format to the local table dictionary format before applying the data.
目标服务器在应用数据之前,将行数据从主字典格式转换为本地表字典格式。
The table dictionary is built only when a REORG is performed, after which the data in the table can be compressed.
只有在执行 REORG 的时候才构建表字典,之后便可以压缩表中的数据。
For other interfaces, the sampling data (used for building the ADC dictionary) remains uncompressed, as seen in Figure 1, until an offline table reorg is performed.
对于其他接口,如图1所示,抽样数据(用于构建adc字典)直到执行离线table reorg时才被压缩。
Setting up the data dictionary in database, which can manage the field information of each object table.
在数据库中建立数据字典,对各个对象数据表的字段信息进行管理。
Setting up the data dictionary in database, which can manage the field information of each object table.
在数据库中建立数据字典,对各个对象数据表的字段信息进行管理。
应用推荐