You may be using Visual Explain or related features to inspect query access plans.
您可能正在使用Visual Explain或相关特性来检查查询访问计划。
You can use the output of Visual Explain or db2exfmt to obtain the query execution plan.
您可以使用Visual Explain或db 2 exfmt的输出来获得查询执行计划。
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语句提供访问路径和相关的统计信息。
Now, if you explain the query (with Visual explain or db2exfmt), you see that the index is used for the case-insensitive search.
现在,如果用Visual Explain或db 2 exfmt解释此查询,就会看到这个不区分大小写的搜索使用了索引。
You can use the output of Visual Explain, Dynamic Explain, or the db2exfmt tool to find out whether an MQT was used to satisfy a query.
您可以使用Visual Explain、Dynamic Explain或db 2 exfmt工具的输出来找出是否使用MQT来满足查询。
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语句的图形化视图,这样您可以分析您的查询和优化它们的性能。
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 can be used on SQL statements in a monitor collection by right-clicking on a monitor and selecting the Show statements task.
可以在一个监视器集合中,通过右键单击一个监视器并选择ShowStatements任务,在sql语句上应用Visual Explain工具。
If Visual Explain is not supported for the type of database that you are connected to, a message tells you that it is not available for your data server.
如果Visual Explain不支持您所连接的这个类型的数据库,它会弹出消息告诉您数据服务器不可用。
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时自动进行创建。
By analyzing the Visual Explain output in Figure 6, from the second query, it is possible to confirm that the optimizer ran with the expected optimization goal of FIRSTIO.
通过分析图6中对于第二个查询的Visual Explain输出,可以证实优化器将达到FIRSTIO的预期优化目标。
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性能。
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),就可以揭示大多数额外的处理(除了索引维护)。
This information is stored in Explain tables, and can later be formatted using tools like visual Explain, db2expln, dynexpln, and db2exfmt to present it in a visual-friendly manner.
该信息存储在explain表中,可以在稍后使用诸如Visual Explain、db 2 expln、dynexpln和db2exfmt的工具进行格式化,从而以友好的可视方式进行表示。
Inspect the optimized SQL in the db2exfmt or Visual Explain output, as this is the basis for the planning decision of the relational data source push-down analysis and the query optimizer.
检查db 2 exfmt或Visual Explain输出中经过优化的SQL,因为这是关系数据源下推分析和查询优化器确定计划的基础。
Since individuals with no visual experience still learn from and imitate others, studies such as this help explain how they can use their other sensory modalities to interact with the world.
由于没有视觉经验的个体仍然具有学习和模仿别人的能力,这种研究有助于解释盲人如何使用自己的其他感官与外界互动。
The findings may explain why people with autism have exceptional visual abilities, said the researchers at the University of Montreal.
蒙特利尔大学的研究人员表示,这项研究解释了为何自闭症患者有着卓越的视觉机能。
Add graphs, drawings, and other graphical explanatory elements and visual cues directly to the source code to help explain a process.
直接在源代码中添加图形、制图或其他图形解释元素和可视化提示,从而帮助解释程序的处理流程。
Moreover, sometimes it happens that the dreamer has some visual images or sensations that he can't tell or explain and, in short words, the dream can't be communicated in its meaningful core.
不仅如此,有时梦者会有一些他无法表达和解释的视觉意象或者感觉,简单地说,就是这个梦不能在语言层面去理解其核心意义。
In response to visual observations of irregularities or bizarre patterns, a researcher is inspired to look for clues that can be used to explain such an unexpected behavior.
利用了对不规则或奇异的模式进行可视化观察,研究者得到灵感,找到用来解释意外现象的线索。
After demonstrating our restrict condition of this parallel visual model, we explain how we realize the visual model in three stage.
说明了我们这个模型的限制条件后,本文从三个阶段介绍了可视化的实现。
Can you explain your idea to someone within 5 minutes using no more than a single sheet of paper and a crayon as visual aids?
你能在五分钟之内不借助一张纸或一张彩图向某人阐述你的设想吗?
Don't teach those abstract contents at the very beginning. It would be better if you explain it by interesting and visual examples.
要是讲的内容比较抽象,千万不要上来就讲,一定要通过形象有趣的例子来解释。
UML can make each component of the large complicated system visual, explain and construct the system model, and build up various documentation?
UML可以对大型复杂的系统的各种成分可视化,说明并构造系统模型,以及建立各种所需的文档。
Also was from the psychology and the physiology visual field carried on elaborating to explain to the game content and the substance.
并对游戏性的内涵以及实质从心理学和生理学视野进行了阐述解释。
These are the most useful comments because they usually help explain the plot, the background story, the significance of lines lost in translation, references, and visual elements easily overlooked.
这些是最有用的评论了,因为它们通常帮助观众解释情节,故事背景,翻译中遗漏了的台词,参考资料,还有容易忽视的视觉要素。
For two years, I struggled to verbally explain the concept to them, with varying results. This year, however, I had a visual tool.
持续两年的时间,我都只能在口头上给他们解释这个概念,取得了一些结果,今年,我终于有了一个直观的工具了。
应用推荐