Listing 13 shows the new access plan.
清单13展示了新的访问计划。
Generate the access plan using db2exfmt as follows.
使用db2exfmt生成访问计划，如下。
Listing 12 shows the basic component of an access plan.
清单12展示了访问计划的基本组件。
Listing 11 shows the access plan for the SELECT statement.
清单11展示了select语句的访问计划。
Database and database manager configuration from the access plan.
访问计划中的数据库和数据库管理程序配置。
This brings little overhead for compiling, but gives an optimal access plan.
这会增加一些编译负载，但却能够产生一个最优的存取计划。
To understand what's going on, let's look at the query and the access plan.
为了理解发生的情况，让我们分析这个查询和存取计划（access plan）。
Figure 10 and Figure 11 show how runstats helped to optimize the access plan.
图10和图11显示了runstats如何帮助优化访问计划。
The access plan can be modeled as a Merge Join (MGJN) of the two sales tables.
访问计划可以建模为两个销售表的合并连接(Merge Join,MGJN)。
Nevertheless, another access plan is generated when parameter markers are used.
然而，使用参数标记时，将生成另一个访问计划。
Generate the access plan using db2exfmt. You will see the following access plan.
使用db2exfmt生成访问计划。
Here are a few examples of the access plan operators you may see in this article.
下面是您可以在本文中看到的一些访问计划操作符例子。
By the way, when you see "GENROW" in an access plan, it is a "generate row" step.
顺便提一下，当您在访问计划中看到“GENROW”时，其实就是一个“generaterow”步骤。
From the access plan, IXSCAN (3) shows one row is expected to be returned from T1.
在上面的存取计划中，IXSCAN(3)显示T1预期会返回一行记录。
Either way you provide the query and the access plan is generated and shown to you.
不管使用哪种方法，都可以生成和显示访问计划。
Let's examine what each of these components means in the context of an access plan.
我们分析一下这些成分在访问计划上下文中的含义。
Follow the same steps as in Example 1 to generate the access plan for the query below
按照和例1同样的步骤生成查询的访问计划
Runstats can also help to optimize the DB2 access plan, which makes DB2 more efficient.
runstats还可以帮助优化DB2 的访问计划，这将使得 DB2更有效率。
After you collect those statistics, you get the new access plan graph shown in Figure 10.
您收集了这些统计数据之后，会得到如图10所示的新访问计划图。
The access plan previously used may not be the best one if the value is changed from 0 to 1.
如果值从0变成1，那么之前所使用的存取计划可能并不是最好的。
Before beginning this tutorial, you should be familiar with the concept of a SQL access plan.
在开始学习本教程之前，您应该熟悉SQL访问计划(access plan)的概念。
Before beginning this tutorial, you should be familiar with the concept of an SQL access plan.
在开始本教程之前，您应该熟悉SQL访问计划的概念。
The access plan is created by the database engine based on the SQL statement that is submitted.
访问计划是由数据库引擎根据提交的sql语句创建的。
The cardinality represents the estimated number of rows returned from the access plan operator.
基数(cardinality)表示访问计划操作符所返回的行的估计数目。
Note that the nickname divisional_sales is shown as one of the objects used in the access plan.
注意，昵称 divisional_sales 显示为访问计划中使用的对象中的一个。
When the index name is not specified, optimizer picks the cheapest single XML index access plan.
如果未指定索引名，优化器将选用成本最低的XML 索引访问计划。
DB2 and IDS USES the statistics information in the catalog table to derive the best access plan.
DB2和IDS使用目录表中的统计信息来制定最佳访问计划。
Figure 12 confirms that the new index on the STAFF table is being used in the query access plan.
图12确认查询的访问计划中使用了staff表上的新索引。
Analyze the query access plan to visualize the choices the optimizer makes in accessing the data.
分析查询访问计划，从而可以切实看到优化器对访问数据作出的选择。
If specified, it requests an access plan using an XISCAN operator over this particular XML index.
如果指定了索引名的话，它将对特定的xml索引使用XISCAN操作符来请求一个访问计划。
应用推荐