Create a temporary keyed access path during execution.
在执行过程中创建临时的关键访问路径。
The access path of the query: How are the tables accessed?
查询的访问路径：如何访问这些表？
The SQL statement in Listing 5 creates the access path graph shown in Figure 5.
清单5中的sql语句创建如图5所示的访问路径图。
The SQL statement in Listing 4 creates the access path graph shown in Figure 4.
清单4中的sql语句创建如图4所示的访问路径图。
The SQL statement in Listing 3 creates the access path graph shown in Figure 3.
清单3中的SQL语句创建如图 3所示的访问路径图
The SQL statement in Listing 6 creates the access path graph shown in Figure 6.
清单6中的sql语句创建如图6所示的访问路径图。
The SQL statement in Listing 8 creates the access path graph shown in Figure 8.
清单8中的sql语句创建如图8所示的访问路径图。
To see the table descriptor, right-click the table node in the access path graph.
为了查看表描述符，请右键单击访问路径图上的表节点。
However, for this example a different access path is selected, which is shown in Figure 7.
然而，对于此示例则选择了一个不同的访问路径，如图7所示。
The inconsistent statistics may also mislead the optimizer into choosing a bad access path.
不一致的统计数据还会误导优化器选择糟糕的访问路径。
This type of access path is referred to as a nested loop join (NLJOIN) with sort composite.
这种类型的访问路径被称为使用复合排序的嵌套循环联接(NLJOIN)。
So, any interruption to one of the access path does not affect storage access from the host.
因此，其中一条访问路径的中断不会影响从主机发起的存储访问。
Keep in mind that this catalog data is what the optimizer USES to make access path decisions.
请记住，优化器使用编目数据决定访问路径。
This article described the basic concepts of access paths and how to read an access path graph.
本文描述了访问路径的基本概念以及如何解读访问路径图。
It does this by performing some work ahead of time, such as determining the database access path.
具体表现就是提前执行一些工作，比如确定数据库访问路径。
With the appropriate access path, the ORDER BY or GROUP BY requirement can be met without sorting.
使用恰当的访问路径，无需排序即可满足ORDERBY或GROUP BY需求。
An index scan is typically shown in Query Tuner as a group of four nodes in the access path graph.
在访问路径图中，一个索引扫描通常作为一组四个节点显示在QueryTuner上。
This tells me that I may have an inefficient access path, where DB2 reads more data than it should.
这就说明我可能有一个低效的访问路径，DB 2读取的数据比应该读取的数据更多。
That simple step could lead to a new access path that might dramatically improve query performance.
这个简单的步骤可能产生新的访问路径，可能显著改进查询性能。
Soft RI in conjunction with statistics may enable the optimizer to generate a more efficient access path.
Soft RI结合统计数据使得优化器能够生成更有效的访问路径。
As you'll see shortly, DB2 can use both of these indexes to generate an efficient access path for our query.
正如您马上就会看到的，DB 2可以使用这两个索引来为我们的查询产生一个高效的访问路径。
Therefore, if the optimizer's estimate is accurate, this access path should be a very efficient access path.
因此，如果优化器的估计是准确的，则此访问路径应该是一个非常有效的访问路径。
You can obtain the statistics from the table descriptor of the table node in the underlying access path graph.
您可以从基础访问路径图中的表节点的表描述符处获得该统计信息。
Intuitively, an access path is a procedural description of query execution that consists of three components.
直观地说，访问路径是查询执行的程序说明，其包括三个组件。
Access plan describes the access path that the DB2 optimizer has chosen for accessing data for an SQL statement.
访问计划描述访问路径，这些路径是DB 2优化器为sql语句访问数据而选择的。
Having the DBMS determine the optimal access path to the data lifts a heavy burden off the programmer's shoulders.
让DBMS确定到数据的最优存取路径解除了程序员肩上沉重的负担。
This means the optimizer will always attempt to formulate an access path for each query that reduces overall cost.
这意味着优化器将始终尝试为每个查询制定减少总体成本的存取路径。
The description of each operation includes a Query Tuner access path graph that explains its operational semantics.
每一个操作的描述都包括一个解释其操作语义的QueryTuner访问路径图。
Data flows from the bottom up (as displayed in the graph) and is processed by operation nodes in the access path graph.
数据从下往上流动(如访问路径图所示)并通过访问路径图上的操作节点处理。
Visual Explain is a new no-charge function that provides access path and related statics for SQL and XQuery statements.
VisualExplain是一个新的免费功能，为SQL和XQuery语句提供访问路径和相关的统计信息。
应用推荐