After you see the advantages of star join optimization, this article provides annotated explain output to show you precisely how star join plan information appears in explain file.
在您看到星型连接优化的优点后，本文通过带有注释的解释输出准确地告诉您星型连接计划的信息是如何出现在解释文件中的。
The explain facility output conveniently displays the real cardinality (section actuals) and the estimated cardinality plan values for your comparison.
解释实用工具输出能够很方便地显示实际基数(片段实绩)和估计的基数计划值，供您进行比较。
You can use the output of Visual Explain or db2exfmt to obtain the query execution plan.
您可以使用VisualExplain或db 2 exfmt的输出来获得查询执行计划。
It is important for a DBA to understand how to look at EXPLAIN output to detect and locate problems in the access plan.
DBA必须知道如何通过观察EXPLAIN结果来检查和定位访问计划中的问题。
It is important for a DBA to understand how to look at EXPLAIN output to detect and locate problems in the access plan.
DBA必须知道如何通过观察EXPLAIN结果来检查和定位访问计划中的问题。
应用推荐