For partitioning indexes, it is recommended that you choose key columns that are unlikely to be changed.
对于分区索引，建议选择不大可能改变的键列。
These recommendations address the database schema, the choice between XML and relational storage, definition of indexes, and physical data organization with partitioning and clustering options.
这些建议涉及了数据库模式、XML与关系存储之间的选择、索引的定义以及带有分区和集群选项的物理数据组织。
The Design Advisor is well suited for optimizing database design for data warehouses as it provides advice on MQTs, MDCs, and DPF partitioning keys in addition to indexes.
Design Advisor 非常适合为数据仓库优化数据库设计，因为除了关于索引的建议之外，它还可以提供关于MQT、MDC和DPF分区键的建议。
As you see in Figure 1, the Design Advisor allows you to select which features you want it to consider, such as indexes, MQT, MDC, and partitioning.
如图1所示，Design Advisor允许选择让它考虑哪些特性，例如索引、MQT、MDC和分区。
The Design Advisor now provides advice on MQTs, MDCs, and DPF partitioning keys in addition to indexes.
除了关于索引的建议以外，Design Advisor现在还可以提供关于MQT、MDC和DPF分区键的建议。
The Design Advisor now provides advice on materialized query tables (MQTs), multidimensional clustering tables (MDCs), and Data partitioning Feature (DPF) partitioning keys, in addition to indexes.
除了索引外，Design Advisor还提供关于物化查询表(MQT)、多维集群表(MDC)和数据分区功能(DataPartitioning Feature,DPF)分区键的建议。
Partitioning enhancements allow tables and indexes to be better partitioned for performance.
分区增强允许表和索引为性能更好的分区。
Partitioning enhancements allow tables and indexes to be better partitioned for performance.
分区增强允许表和索引为性能更好的分区。
应用推荐