Figures 13 and 14 show the Design Advisor.
图13和图14显示了Design Advisor。
Ensure runstats has been done prior to the Design Advisor execution.
确保在Design Advisor执行之前运行了runstats。
The Design Advisor has several options to input and collect the workload.
Design Advisor有一些选项来输入和收集工作负载。
The DB2 Design Advisor is a utility that automatically recommends indexes.
DB 2Design Advisor是一个能够自动推荐索引的工具。
Figure 13 shows the kind of results possible with tools like the Design Advisor.
图13展示了Design Advisor等工具可能产生的结果。
You can access the Design Advisor either as a GUI tool or through the command line.
您可以将Design Advisor作为一种GUI工具，或者通过命令行来使用它。
As a result, the Design Advisor will analyze a larger set of the workload you provided.
结果，Design Advisor将分析您提供的更大一组的工作负载。
Step 1: Use the Design Advisor to determine a set of MQTs that will help your query workload.
步骤1：使用Design Advisor来确定将会有助于改善查询工作负载性能的MQT集合。
The Design Advisor can provide recommendations comparable to that of a database tuning expert.
Design Advisor所提供的建议能与数据库调优专家的建议相媲美。
Re-run the Design Advisor with different inputs to see if you can get a better recommendation.
用不同的输入重新运行Design Advisor，看看能否获得更好的建议。
The option -r instructs the Design Advisor to use extended statistics for the considered MQTs.
选项-r指示Design Advisor为考虑的 MQT使用扩展的统计信息。
The Design Advisor is often used in conjunction with other DB2 features. Some examples include
Design Advisor经常与其他DB2特性一起使用。
You can start the Design Advisor from the db2 Control Center, or by using the db2advis command.
您可以从db 2ControlCenter启动Design Advisor，或者使用db2advis命令启动。
The Design Advisor has new detailed reports that provide deeper insight into the recommendations.
Design Advisor有新的详细报告，其中对建议给予了更深入的分析。
In this article we focus on how to use the Design Advisor to recommend MQTs for federated queries.
在本文中，我们着重讲述如何使用Design Advisor来为联邦查询推荐MQT。
Optionally, you can overwrite the default schema with the -q option when calling the Design Advisor.
在调用Design Advisor时，您也可以选择使用- q选项覆盖默认模式。
The option -r has no effect when the Design Advisor is used to recommend MQTs for federated queries.
当Design Advisor用于为联邦查询推荐MQT时，选项- r没有效果。
The last two options are available only from the Design Advisor GUI, and not the command line version.
最后两个选项只有在Design AdvisorGUI中才能使用，而命令行版本中没有提供这两个选项。
You can use the Design Advisor to see if indexes would result in an access plan with fewer table scans.
那么这时可以使用Design Advisor，看看索引是否能导致不需要扫描那么多表的访问计划。
The Design Advisor now provides advice on MQTs, MDCs, and DPF partitioning keys in addition to indexes.
除了关于索引的建议以外，Design Advisor现在还可以提供关于MQT、MDC和DPF分区键的建议。
When calling the Design Advisor, you have to define the set of SQL statements that you want to analyze.
当调用Design Advisor 时，您必须定义需要对其进行分析的SQL语句组。
Stay tuned for Part 2, when we’ll look at how to use the Design Advisor in a data warehouse environment.
请继续关注第 2部分，到时候我们将研究如何在数据仓库环境中使用Design Advisor。
You can then elect to use the Design Advisor to help find indexes to mitigate this performance degrader.
然后采用Design Advisor来帮助发现有助于缓解这种性能下降的索引。
Once you've identified the need to use the Design Advisor, follow the steps listed below to use the tool.
确定需要使用Design Advisor之后，请遵循下面列出的步骤来使用该工具。
The last column lists the customizations we made to the MQTs that were recommended by the Design Advisor.
最后一列列出我们对Design Advisor推荐的MQT所做的定制。
In this case, we direct the Design Advisor to read the workload from a file which contains the transactions.
在这个案例中，我们让Design Advisor从一个包含事务的文件中读取工作负载。
You need to edit the syntax in the recommendations given by Design Advisor to use no system-maintained MQTs.
为了使用系统维护的MQT，需要编辑Design Advisor给出的建议中的语法。
The DB2 Design Advisor, a built-in administrative tool, can advise administrators about their partitioning design.
内置管理工具DB2Design Advisor可以提供分区设计建议。
The Design Advisor provides you with an easy and fast way to determine which indexes are best for your workload.
Design Advisor为您提供了一种轻松、快捷的方法来确定哪些指标对于工作负荷来说是最佳的。
Additionally, rerun the Design Advisor against the dynamic SQL cache populated by a full scale application test.
此外，针对由完整应用程序测试填充的动态sql缓存重新运行Design Advisor。
应用推荐