The SQL statement in Listing 5 creates the access path graph shown in Figure 5.
清单5中的sql语句创建如图5所示的访问路径图。
The SQL statement in Listing 6 creates the access path graph shown in Figure 6.
清单6中的sql语句创建如图6所示的访问路径图。
The SQL statement in Listing 3 creates the access path graph shown in Figure 3.
清单3中的SQL语句创建如图 3所示的访问路径图
The SQL statement in Listing 4 creates the access path graph shown in Figure 4.
清单4中的sql语句创建如图4所示的访问路径图。
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.
为了查看表描述符，请右键单击访问路径图上的表节点。
This article described the basic concepts of access paths and how to read an access path graph.
本文描述了访问路径的基本概念以及如何解读访问路径图。
An index scan is typically shown in Query Tuner as a group of four nodes in the access path graph.
在访问路径图中，一个索引扫描通常作为一组四个节点显示在QueryTuner上。
You can obtain the statistics from the table descriptor of the table node in the underlying access path graph.
您可以从基础访问路径图中的表节点的表描述符处获得该统计信息。
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.
数据从下往上流动(如访问路径图所示)并通过访问路径图上的操作节点处理。
An access path graph not only describes the "operational details" of query execution, it also describes how the data flows.
访问路径图不但描述“操作细节”，而且描述数据如何流动。
Similarly, the last leg in the access path graph is evaluated eight times, once for each record produced by the first NLJOIN node.
同样，访问路径图的最后一步要评估8次，通过第一个NLJOIN节点产生的每条记录都要评估一次。
In Figure 2, the descriptor for the table node and the descriptor for the TBSCAN node are shown to the left of the access path graph.
在图2中，表节点的描述符和TBSCAN节点的描述符显示在访问路径图的左侧。
The SQL statement in Listing 2 creates the access path graph shown on the right side of the Optim Query Tuner screenshot in Figure 2.
清单2中的sql语句创建如图2上的OptimQueryTuner截图右侧所示的访问路径图。
This section illustrates how the query Tuner query annotation and access path graph can help you analyze access paths and SQL performance.
本部分说明QueryTuner查询注释和访问路径图如何帮助您分析访问路径和SQL性能。
Table 1 describes the input, output, and function of several operation nodes that typically appear in an Optim Query Tuner access path graph.
表1描述通常出现在OptimQueryTuner访问路径图上的输入、输出和几个操作节点的功能。
Using LISREL analyses the data got from the survey, the six paths all pass the test of the model. The model path graph is also given by LISREL.
借助LISREL软件对调查所得的数据进行分析，得出这六条路径都通过了模型检验，并画出了相应的模型路径图。
The rest of this section takes you through the access path graph one more time from the data flow perspective so that you can gain a full understanding of the performance aspect of query execution.
本节的其余部分再一次以数据流的观点向您介绍访问路径图以便您可以在查询执行的性能方面获得充分的理解。
The rest of this section takes you through the access path graph one more time from the data flow perspective so that you can gain a full understanding of the performance aspect of query execution.
本节的其余部分再一次以数据流的观点向您介绍访问路径图以便您可以在查询执行的性能方面获得充分的理解。
应用推荐