Finally, use an explain tool such as db2exfmt to see the access plan utilizing current and recommended indexes.
最后,利用当前和建议的索引使用诸如db2exfmt的解释工具查看访问计划。
The Visual Explain tool provides a graphic view of your SQL statements so that you can analyze your queries and tune them for better performance.
Visual Explain工具提供了一个sql语句的图形化视图,这样您可以分析您的查询和优化它们的性能。
The Visual Explain tool can be used on SQL statements in a monitor collection by right-clicking on a monitor and selecting the Show statements task.
可以在一个监视器集合中,通过右键单击一个监视器并选择Show Statements任务,在sql语句上应用Visual Explain工具。
应用推荐