The standard diagnostic tools in db2 such as visual explain, db2exfmt, and the snapshot monitor can be used for XML performance investigations just like for relational data.
和对待关系数据一样,可以使用db 2中的标准诊断工具(例如visual explain、db2exfmt和快照监视器)来调查XML性能。
How Visual explain is used to view explain snapshot data?
使用Visual Explain查看解释快照数据的方法。
You may be using Visual Explain or related features to inspect query access plans.
您可能正在使用Visual Explain或相关特性来检查查询访问计划。
Visual Explain also includes information on the database objects considered and chosen by the query optimizer.
Visual Explain还包括关于查询优化器所考虑和选择的数据库对象的信息。
Visual Explain, which is available through the DB2 Control Center, is the simplest way to view an access plan.
可视化解释(Visual Explain)是查看访问计划的最简单方式,通过DB 2ControlCenter实现。
Visual Explain is a new no-charge function that provides access path and related statics for SQL and XQuery statements.
Visual Explain是一个新的免费功能,为SQL和XQuery语句提供访问路径和相关的统计信息。
Plus, DB2 Visual Explain only describes what the database is doing; it doesn't provide insight into the performance ramifications of that choice.
另外,DB 2Visual Explain只描述数据库正在做什么;它并不提供性能调优建议。
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语句的图形化视图,这样您可以分析您的查询和优化它们的性能。
To determine if asynchrony was enabled within a federated query, view the access plan of the query using db2exfmt,Visual Explain or a tool of your choice.
要确定一个联邦查询中是否启用了异步,可以使用db2exfmt、Visual Explain或您选择的其他工具来查看查询的访问计划。
Explain tables may be created automatically the first time you use Visual Explain. If they have not been created, you can manually create them as follows.
explain表可以在您第一次使用Visual Explain时自动进行创建。
Running a form of Explain (such as Visual Explain, or the Explain statement plus db2exfmt) against your insert will reveal most of the extra processing (but not index maintenance).
对insert运行某种形式的Explain (例如Visual Explain,或者 Explain语句加上db2exfmt),就可以揭示大多数额外的处理(除了索引维护)。
UML can make each component of the large complicated system visual, explain and construct the system model, and build up various documentation?
UML可以对大型复杂的系统的各种成分可视化,说明并构造系统模型,以及建立各种所需的文档。
UML can make each component of the large complicated system visual, explain and construct the system model, and build up various documentation?
UML可以对大型复杂的系统的各种成分可视化,说明并构造系统模型,以及建立各种所需的文档。
应用推荐