Typed table, range partitions, or MDC tables.
类型表、范围分区或mdc表。
MDC supports defining multiple dimensions.
MDC则支持定义多个维。
TP cannot be used to rectify a poor MDC design.
TP不能用于纠正不好的MDC设计。
For MDC tables, the number of blocks that contain data.
对于mdc表,还有包含数据的块(block)数。
For example, an MQT can be partitioned using MDC or TP.
例如,可以使用MDC或TP对MQT分区。
MDC contributes by making it efficient to retrieve data.
MDC对性能的贡献在于提高检索数据的效率。
Base tables that include MDC or partitioning recommendations.
包括MDC或分区建议的基本表。
MDC block indexes means that fewer RID indexes are required.
MD c块索引意味着需要的RID索引更少。
This enhancement for MDC tables provides the following benefits.
用于mdc表的这种增强提供了以下好处。
MDC will only benefit those queries that include dimension columns.
MDC只对那些包括维列的查询有好处。
When DB2 encounters an INSERT on an MDC table, it looks for a free block.
当DB 2碰到对mdc表的INSERT操作时,它寻找一个空闲的块。
When scanning an MDC table, block locking could be deferred for an index scan.
当扫描一个mdc表时,对于索引扫描,块锁可以推迟。
For example, an MQT can be created on one or more tables that USES MDC and TP.
例如,可以在一个或多个使用MDC和TP的表上创建MQT。
It USES the mapped diagnostic context class (MDC) available in Log4J 1.3 alpha.
它使用了Log4J 1.3alpha中提供的映射诊断上下文类(MDC)。
With MDC tables, data is organized into blocks according to dimension values.
对于mdc表,数据根据维值被组织到块中。
Logs and removes the block index (BID) index entry from the MDC table's block indexes.
记录并删除mdc表的块索引中的块索引(BID)索引项。
Efficiency of SAP BW with key BI-related objects like MDC tables for even faster performance.
SAPBW的高效性通过关键的BI有关对象,如mdc表,以获得更快的性能。
Having lost faith in Mr Mbeki, the MDC also wants a full-time mediator from the African Union.
MDC已经对姆贝基先生失去信心,它希望非盟派出一名全职的仲裁专使。
On the other hand, with MDC it is advisable to pre-sort the data according to the MDC dimensions.
另一方面,如果使用MDC,建议预先根据 MDC 维对数据进行排序。
This article introduced the following DB2 table design features: table partitioning, MDC, DPF, and MQT.
本文介绍了以下DB2表设计特性:表分区、MDC、DPF和 MQT。
Multi DIMENSIONAL CLUSTERING (MDC) - organizing data in table (or range of a table) by multiple key values.
MULTIDIMENSIONALCLUSTERING (MDC)——根据多个键值组织表(或一个表中的范围)中的数据。
TP, introduced in DB2 9, is similar to MDC in that it enables rows with similar values to be stored together.
TP是在DB29 中引入的,与MDC类似,它也可以将具有近似值的行存储在一起。
If the target table is a multidimensional clustering (MDC) table, the source table must also be an MDC table.
如果目标表是多维集群化(Multidimensional Clustering,mdc)表,则源表也必须是mdc表。
MDC is uniquely suited to situations which are more demanding, but less common, than the basic roll-out situation.
MDC是惟一适合以下情况的特性,与基本转出相比,下面这些情况要求更高,但是不大常见。
In summary, if there is a problem with DPF, MDC, or TP, then remedies applicable to that feature need to be attempted.
总之,如果存在与D PF、MDC或TP相关的问题,那么还是应该尝试适用于那个特性的解决方法。
Essentially, MDC is a feature that maximizes performance of queries, especially those commonly found in data warehouses.
实际上,MDC是一个能最大化查询性能的特性,对于数据仓库中常用的查询更是如此。
Generally, one of the MDC dimensions will be a time-based column so the same column can be used for both MDC and TP.
通常,有一个mdc维是基于时间的列,这样一来,同一个列既可以用于MDC,又可以用于TP。
In the next version of the SAP BW product, the Fact tables will use a multidimensional clustering (MDC) table to store data.
在下一个版本的SAPBW产品中,fact表将使用多维集群(multidimensional clustering,MDC)表来存储数据。
To deliver on its potential performance, MDC tables must be designed with the optimal (or at least an adequate) set of dimensions.
为了发挥它潜在的性能,必须为mdc表设计一组最佳的(或者至少是够好的)维。
To deliver on its potential performance, MDC tables must be designed with the optimal (or at least an adequate) set of dimensions.
为了发挥它潜在的性能,必须为mdc表设计一组最佳的(或者至少是够好的)维。
应用推荐