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分区键的建议。
The Design Advisor now provides advice on MQTs, MDCs, and DPF partitioning keys in addition to indexes.
除了关于索引的建议以外，Design Advisor现在还可以提供关于MQT、MDC和DPF分区键的建议。
The db2 Design Advisor is the most straightforward tool for obtaining efficient partitioning Suggestions and can be accessed from the Control Center GUI or db2advis command line tool.
db 2Design Advisor是获得有效的分区建议的最直接的工具，可以通过ControlCenterGUI或db2advis命令行工具来使用它。
The DB2 Design Advisor, a built-in administrative tool, can advise administrators about their partitioning design.
内置管理工具DB2Design Advisor可以提供分区设计建议。
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 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)分区键的建议。
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)分区键的建议。
应用推荐