From this new access plan graph, you can see the following.
在这张新访问计划图中,您可以看到以下内容。
From the access plan graph in Figure 6, you can see the following.
在图6中访问计划图中,您可以看到以下内容。
From the access plan graph in Figure 6, you can do some initial performance analysis.
在图6的访问计划图中,您可以做一些初始性能分析。
After you collect those statistics, you get the new access plan graph shown in Figure 10.
您收集了这些统计数据之后,会得到如图10所示的新访问计划图。
After creating the three new indexes, you get the new access plan graph shown in Figure 13.
创建三个新索引之后,您图13中的新访问计划图。
From the access plan graph, you can see what choices the optimizer has made regarding how the query will be processed and the rationale for those choices.
从这张访问计划图中,您可以看到优化器对如何处理查询作出何种选择以及理由。
It includes how to understand the problem query better by using the visual AIDS provided by query formatting, annotation, reports, and the access plan graph.
其中包含如何通过使用查询格式化、注释、报告和访问计划图来更好地理解问题查询。
There is an attribute RUNSTATS TIMESTAMP on the table or index node of the access plan graph that indicates the last time when the statistics were collected.
在访问计划图的表或索引节点上会有一个RUNSTATSTIMESTAMP属性,它表示收集统计数据的时间。
So far, you've seen how you can analyze and tune a problem query with the assistance of Optim query Tuner capabilities, such as query annotation, access plan graph, and so on.
到目前为止,您已经看到如何在OptimQueryTuner各项功能的帮助下分析和调优问题查询,这些功能包括查询注释、访问计划图等等。
As a simple example, the following graph (produced by db2exfmt) shows the access plan for an "Insert into Test1 values (?,?,...)".
作为一个简单的例子,下面的图由db 2 exfmt产生展示了“Insertinto test1 values?”语句的访问计划。
As a simple example, the following graph (produced by db2exfmt) shows the access plan for an "Insert into Test1 values (?,?,...)".
作为一个简单的例子,下面的图由db 2 exfmt产生展示了“Insertinto test1 values?”语句的访问计划。
应用推荐