大家在查： sawing 打成一片卡比拉 peed 换算 flexibly 胜券物欲 cautioning Zachary

DesignAdvisor

网络设计顾问；设计建议程序；设计顾问程序

DesignAdvisor

网络释义

DesignAdvisor

设计顾问

在 DB2 中有两个主要的顾问：配置顾问（Configuration Advisor）和设计顾问（Design Advisor）。配置顾问用来为 DB2 环境 …

设计建议程序

建议程序有两种：配置建议程序（Configuration Advisor）和设计建议程序（Design Advisor）。例如，您可以启动配置建议程 …

设计顾问程序

此外，用户还可以使用 DB2 提供的设计顾问程序（Design Advisor）分析复杂查询派生的 SQL 语句，利用提供的建议来创建索 …

流道设计精灵

流道设计精灵(Design Advisor)以非常简洁的方式引导设计人员进行流道设计，根据铸件质量、体积、几何尺寸和材质，预算充 …

例句：

The Design Advisor can provide recommendations comparable to that of a database tuning expert .

DesignAdvisor 所提供的建议能与数据库调优专家的建议相媲美。

As you see in Figure 2 , the Design Advisor generated a set of recommendations that would lead to a 60% improvement in performance .

从图 2 可以看到，DesignAdvisor 生成了一组建议，这些建议将导致性能提升 60%。

A major determinant of the resources used by the Design Advisor is the size of the workload that you provide for it to analyze .

决定 DesignAdvisor 所使用资源多少的主要因素是您提供给它、让它分析的工作负载的大小。

You can use the Design Advisor to see if indexes would result in an access plan with fewer table scans .

那么这时可以使用 DesignAdvisor ，看看索引是否能导致不需要扫描那么多表的访问计划。

As you see in Figure 4 , the Design Advisor generated a set of recommendations that would lead to almost 20% improvement .

从图 4 可以看到，DesignAdvisor 生成了一组建议，这些建议将导致大约 20%的性能提升。

In an internal experimental test , the Design Advisor was able to increase the performance of an un-tuned DB2 UDB database by 84%!

在内部实验的测试中，DesignAdvisor 可以将未调优的 DB2UDB 数据库性能提高 84%！

The Design Advisor provides you with an easy and fast way to determine which indexes are best for your workload .

DesignAdvisor 为您提供了一种轻松、快捷的方法来确定哪些指标对于工作负荷来说是最佳的。

Selecting the option to tune the workload would result in a different course of action ; in this case , it would launch the Design Advisor.

选择调整负载的选项将得到不同的行动路线；在这种情况下，将启动 DesignAdvisor 。

Re-run the Design Advisor with different inputs to see if you can get a better recommendation .

以不同的输入重新运行 DesignAdvisor ，看看能否获得更好的建议。

You can then elect to use the Design Advisor to help find indexes to mitigate this performance degrader.

然后采用 DesignAdvisor 来帮助发现有助于缓解这种性能下降的索引。

Additionally , rerun the Design Advisor against the dynamic SQL cache populated by a full scale application test .

此外，针对由完整应用程序测试填充的动态 SQL 缓存重新运行 DesignAdvisor 。

Since sampling is not supported on nicknames , the Design Advisor uses the optimizer 's estimates for statistics .

因为不支持在昵称上采样，所以 DesignAdvisor 使用优化器评估的统计信息。

Let 's run the advisor again and remove this restriction to see if we get a better result .

让我们再次运行 DesignAdvisor ，并去掉这个限制，看是否可以获得更好的结果。

In this case , we direct the Design Advisor to read the workload from a file which contains the transactions .

在这个案例中，我们让 DesignAdvisor 从一个包含事务的文件中读取工作负载。

Once a schema has been developed and is available , use the Design Advisor to recommend indexes using SQL statements as input .

一旦开发出了一种模式并且可以使用，将 SQL语句作为输入使用 DesignAdvisor 来建议索引。

Also note that by default , the Design Advisor focuses a subset of the workload that consists of the most expensive statements .

还应注意的是，默认情况下，DesignAdvisor 着重考虑工作负载中由代价最昂贵的语句组成的子集。

In this situation , the major consideration is the potential impact of running the Design Advisor on the production system .

在这种情况下，主要考虑的是运行 DesignAdvisor 对生产系统的影响。

As already mentioned when discussing use of the Design Advisor, you have to be careful when interpreting index usage information .

在讨论 DesignAdvisor 时已经提到，在解释索引使用信息时必须格外小心。

Next , you can run the Design Advisor which retrieves these statements in memory , and determines the necessary indexes .

接下来，运行 DesignAdvisor ，从内存中获取这些语句，并确定必需的指标。

With your workload file in hand, you can launch the Design Advisor.

有了工作负载文件，便可以启动 DesignAdvisor 。

Copy the database to a separate test system and run the Design Advisor there .

将数据库复制到一个独立的测试系统中，并在那里运行 DesignAdvisor 。

Optionally, you can overwrite the default schema with the -q option when calling the Design Advisor.

在调用 DesignAdvisor 时，您也可以选择使用 -q 选项覆盖默认模式。

Before using the Design Advisor, you need to determine how to get a representative sample of the workload to provide as input .

在使用 DesignAdvisor 之前，需要确定如何获得代表性的工作负载样本，以作为它的输入。

Calling the Design Advisor this way requires less effort than using a manually created input file containing SQL statements.

以这种方式调用 DesignAdvisor 比手动地创建包含 SQL语句的输入文件要省事得多。

DesignAdvisor

DesignAdvisor

设计顾问

设计建议程序

设计顾问程序

流道设计精灵

热词推荐

大家在看