DB2 provides GUI and command line tools to see explain plan of a query.
DB 2提供的GUI和命令行工具可以用来查看查询的解释计划。
It can also capture queries from SQL cache and produce the explain plan.
它还可以从SQL缓存捕获查询并生成解释计划。
You can use tools to see the explain plan of SQL's in all stored procedures.
可以使用工具查看所有存储过程中的SQL的解释计划。
Set AUTOTRACE ON: Produces the result set and the explain plan, and lists statistics.
真正执行查询，显示查询结果集，显示执行计划，显示统计数据。
EXPLAIN and STATISTICS options enable the display of explain plan and statistics information, respectively.
EXPLAIN和STATISTICS选项分别支持显示说明计划和统计信息。
If we look at the explain plan (located in sqexplain.out), we begin to see the problem (my notes in bold).
如果我们看一下解释计划(位于sqexplain . out中)，我们就会开始了解该问题(见粗体的注意部分)。
The explain plan shows 72838, optimizer think it has good filtration. So put this JOIN in the first order. Actually, it is totally wrong.
执行计划显示72838，这里优化器认为它有良好的过滤芯，所以把它放在一个多个表join的第一位置。显然，它完全错了。
Set AUTOTRACE TRACEONLY: Displays the explain plan and the statistics; you will not see the result set, although the statement is executed.
真正执行查询，但不显示查询结果集，显示执行计划，显示统计数据。
You will note that the creators of the benchmark were kind enough to turn on the explain plan, so that is built in the current directory. There is a timer on the entire run.sh.
您可能会注意到，基准的创建者以很友好的方式来进行计划解释，因此它被构建到当前目录中。
By using active and passive management for ORACLE and optimize tools like SQL TRACE EXPLAIN PLAN and ORACLE OPTIMIZER, the query response time is shortened and the efficiency is improved.
通过对Oracle性能的主动和被动管理，以及优化工具SQLTrace、EXPLAIN PLAN和优化器的使用，缩短了数据仓库用户查询响应的时间，提高了查询效率。
When you take children to other kinds of stores, explain how to plan purchases in advance and make unit-price comparisons.
当你带孩子去其他类型的商店时，解释如何事先计划所买的东西和如何做单价比较。
There's no plan: If your adviser can't explain how he intends to make sure you can retire at 65, there's a problem.
没有具体计划——如果你的理财顾问自己都不能向你解释为什么你要在65岁退休。那么，这肯定出问题了。
This file is cumulative, in other words, if you have multiple SQL queries after SET EXPLAIN on statement, each query execution plan and its costs would be appended to this file until it is removed.
该文件是累积的，换言之，如果SETEXPLAINON语句之后有多个SQL查询，每个查询的执行计划及其成本都会被追加到文件中，直到将之删除。
Take responsibility for them and, if you think it's necessary, explain how you plan to improve your performance at your new school.
为此承担责任，同时，如果你认为必要，解释一下你将计划如何在新学校里提高自己的成绩。
After you see the advantages of star join optimization, this article provides annotated explain output to show you precisely how star join plan information appears in explain file.
在您看到星型连接优化的优点后，本文通过带有注释的解释输出准确地告诉您星型连接计划的信息是如何出现在解释文件中的。
At this point you'll want to explain the basics of the SOA concept to all project teams serving the business and plan a strategy for a feedback and suggestion process.
此时，您将需要向为业务服务的所有项目团队说明soa的基本概念，并拟订与反馈和建议流程有关的策略计划。
This now populates the explain tables with the access plan chosen by the optimizer based on real and virtual indexes.
现在将用优化器根据实际和虚拟索引选择的访问计划来填充解释表。
You can delve deeper into how a query is written by prepending EXPLAIN to the query, which will return the query plan instead of the result set, as show in Listing 2.
您可以更深入地钻研如何写查询，即在查询开始处加上EXPLAIN，它会返回查询计划，而非结果集，如清单 2 所示。
The SQL explain facility provides detailed information about the access plan that the query optimizer chooses for an SQL statement.
SQL解释工具提供查询优化器为 SQL语句所选择的访问计划的有关详细信息。
This week he returned to Washington to explain the snappy beauty of his “9-9-9” plan to revive the economy by scrapping the income tax and replacing it with a flat tax and sales tax.
本周，他返回华盛顿，解释他的“9-9-9”计划是怎样充满生机，魅力动人，这个计划旨在用统一税和销售税代替收入税来复苏经济。
The explain facility output conveniently displays the real cardinality (section actuals) and the estimated cardinality plan values for your comparison.
解释实用工具输出能够很方便地显示实际基数(片段实绩)和估计的基数计划值，供您进行比较。
It is important for a DBA to understand how to look at EXPLAIN output to detect and locate problems in the access plan.
DBA必须知道如何通过观察EXPLAIN结果来检查和定位访问计划中的问题。
Such worries also explain the unease over Mr Sarkozy's plan to abolish investigating judges, who have sweeping powers to collect evidence, question witnesses and decide to send suspects for trial.
此般担忧同样昭示了对萨尔科齐废除预审调查法官计划的不安，这一职务在收集证据、询问证人以及决定指控嫌疑人上具有广泛的权利。
It reads the SQL statements executed from the event monitor tables and runs the Explain utility for each statement to generate the corresponding access plan.
它将读取从事件监控器表执行的sql语句，然后对每个语句运行Explain实用程序以生成对应的访问计划。
To determine if asynchrony was enabled within a federated query, view the access plan of the query using db2exfmt,Visual Explain or a tool of your choice.
要确定一个联邦查询中是否启用了异步，可以使用db2exfmt、VisualExplain或您选择的其他工具来查看查询的访问计划。
The db2exfmt tool reads the data in the EXPLAIN tables, and formats the query access plan in a text file
db2exfmt工具读取EXPLAIN表中的数据，并将查询访问计划以文本文件的形式呈现
Visual Explain, which is available through the DB2 Control Center, is the simplest way to view an access plan.
可视化解释(Visual Explain)是查看访问计划的最简单方式，通过DB 2ControlCenter实现。
To view the query access plan using the optimization profile created, the SET CURRENT optimization profile statement can be used in combination with the SET CURRENT EXPLAIN MODE statement, as follows.
要查看使用了创建的优化配置文件的查询访问计划，可以结合使用SETCURRENTOPTIMIZATIONprofile语句和SET CURRENTEXPLAINMODEstatement，如下所示。
The EXPLAIN tool, which requires the existence of the EXPLAIN tables, can be used to view the query access plan chosen by the optimizer. To create the EXPLAIN tables, execute.
EXPLAIN工具可以用于查看优化器选择的查询访问计划，要使用该工具需要有explain表。
The EXPLAIN tool, which requires the existence of the EXPLAIN tables, can be used to view the query access plan chosen by the optimizer. To create the EXPLAIN tables, execute.
EXPLAIN工具可以用于查看优化器选择的查询访问计划，要使用该工具需要有explain表。
应用推荐