Explain the data into explain tables.
将数据解释到解释表中。
Before you do this, you must create the EXPLAIN tables.
首先必须创建explain表。
Migrate db2 explain tables, if you need them, by running.
如果需要的话,迁移db 2explain表,运行下面的命令。
Call EXPLAIN_FROM_ACTIVITY to populate the explain tables.
调用EXPLAIN _ FROM_ACTIVITY填充解释表。
Note that you must have the explain tables created before this example.
请注意,在开始这个例子之前,您必须先创建解释表。
The db2exfmt tool is used to format the contents of the explain tables.
db 2 exfmt工具用于格式化解释表的内容。
You must have the explain tables created before you follow this example.
在继续进行本示例之前,您必须先创建解释表。
Call the explain_from_activity procedure to populate the explain tables.
调用explain _ from_activity过程填充解释表。
Before you can use this tool, you must create the EXPLAIN tables for the database.
使用该工具前必须创建数据库的explain表。
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,它会从解释表提取信息,然后用一种格式化输出显示。
应用推荐