Migrate db2 explain tables, if you need them, by running.
如果需要的话，迁移db 2explain表，运行下面的命令。
The db2exfmt tool is used to format the contents of the explain tables.
db 2 exfmt工具用于格式化解释表的内容。
Once the EXPLAIN tables are created, you are ready to run the following query in EXPLAIN mode
创建了EXPLAIN表之后，就可以用 EXPLAIN模式运行下面的查询
These output parameters can be used to locate explain information for the section in the explain tables.
这些输出参数可用于定位解释表中该片段的解释信息。
Note: You must make sure that the explain tables are created before following the steps in this example.
注意：在继续本例的后续步骤之前，您必须先创建解释表。
These output parameters can be used to locate explain information for the section in the explain tables.
这些输出参数可用于在解释表中定位该片段的信息。
The db2exfmt tool reads the data in the EXPLAIN tables, and formats the query access plan in a text file
db2exfmt工具读取EXPLAIN表中的数据，并将查询访问计划以文本文件的形式呈现
The stored procedures output the key fields for the explain instance that was populated in the explain tables.
存储过程会输出之前在解释表中填充的explain实例的关键字段。
Finally, create explain tables so that you will be able to run explain to understand what the optimizer is doing.
最后，创建解释表，这样您就能够执行解释以了解优化器的操作。
This now populates the explain tables with the access plan chosen by the optimizer based on real and virtual indexes.
现在将用优化器根据实际和虚拟索引选择的访问计划来填充解释表。
Stop and start the instance, using db2stop and db2start. Create the explain tables again for this DUMMYDB database.
使用db2stop和db2start停止并启动该实例。
The explain information is stored in the explain tables, which can be further processed by explain formatting utility, such as db2exfmt.
这些解释信息会存储在解释表中，它可以由解释格式化实用工具进一步加以处理，如db2exfmt。
Finally, understanding how the EXPLAIN tables relate and how to interpret the information contained in them can be intimidating and cryptic.
最后，掌握如何使用explain表和解释其中包含的信息对于开发人员来说并不容易。
If no value or NULL is specified for this argument, it will first look for explain tables under current authorization ID, then under SYSTOOLS schema.
如果这个参数不指定值或者指定为NULL，那么它首先会查找当前授权ID下的解释表，然后再在SYSTOOLS模式下查找。
If no value or NULL is specified for this argument, it will first look for explain tables under current authorization ID then under the SYSTOOLS schema.
如果这个参数没有指定值或者指定为NULL，那么它首先会查找当前授权ID下的解释表，然后再在SYSTOOLS模式下查找。
The optional input or output argument explain_schema can be used to specify the schema for the explain tables where explain information should be saved.
可选的输入或输出参数explain_schema可用于指定保存解释信息的解释表的模式。
The optional input or output argument explain_schema can be used to specify the schema for the explain tables where explain information should be saved.
可选的输入或输出参数explain_schema可用于指定保存explain信息的解释表的模式。
Explain tables may be created automatically the first time you use Visual Explain. If they have not been created, you can manually create them as follows.
explain表可以在您第一次使用Visual Explain时自动进行创建。
Db2exfmt requires that an SQL statement has been previously explained into these tables, and formats the contents of the information in the explain tables.
db 2 exfmt需要已经将一条sql语句解释到这些表中，并设置explain表中信息内容的格式。
Like the other section explain procedures, it stores the explain output in the explain tables for processing using any existing explain tools, such as db2exfmt.
与其他片段解释过程类似，它会将解释输出存储到解释表中，以便使用任何现有的EXPLAIN工具进行处理，如db2exfmt。
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表。
This information is stored in Explain tables, and can later be formatted using tools like visual Explain, db2expln, dynexpln, and db2exfmt to present it in a visual-friendly manner.
该信息存储在explain表中，可以在稍后使用诸如Visual Explain、db 2 expln、dynexpln和db2exfmt的工具进行格式化，从而以友好的可视方式进行表示。
These key fields can be used as input to existing explain formatting tools, for example db2exfmt, which extract the information from the explain tables and present it in a formatted output.
这些关键字段可作为现有解释格式化工具的输入，例如db2exfmt，它会从解释表提取信息，然后用一种格式化输出显示。
My version includes a section to explain the columns in subsequent tables.
我的版本包括了解释及表中列含义的部分。
The EXPLAIN_FROM_CATALOG procedure produces explain information about a statement using the content of the section from the catalog tables.
EXPLAIN_FROM_CATALOG过程将使用目录表中的片段内容生成有关一条语句的解释信息。
The exception would be if the query work load results in many TEMP tables being created (you can determine this by using the explain utility).
如果查询工作负载导致创建许多TEMP表（您可以通过使用解释实用程序来确定）时除外。
He spent 2008, the election year, at the University of Cambridge in England and found himself in lecture halls and at dinner tables trying to explain who this man was.
他在英国剑桥大学度过了美国的2008大选年，发现自己需要在演讲大厅和晚餐餐桌上向英国人解释这个人是谁。
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实用程序以生成对应的访问计划。
I just need to explain to you what this way of multiplying tables of Numbers means.
我只是解释一下，这种把数字列表相乘的方法表示的什么意思。
All this has made it much easier to create maps that explain-at a glance-something that might otherwise require pages of tables or verbiage.
所有这些使得通过创建地图解释一些总量变得更容易——结果可以一目了然——如果不用这种方式，可能需要几页的表格或者冗长的文字。
应用推荐