The rewritten query known as "Optimized SQL" is visible when you explain the statement with the db2exfmt command.
重写后的查询也称为“OptimizedSQL”,它将在使用db2exfmt命令解释语句时出现。
I can't explain such a statement by him on the basis of logic. He must have blown his top.
我从逻辑推理方面解释不了他讲的这番话,他想必是神经错乱了。
The SQL explain facility provides detailed information about the access plan that the query optimizer chooses for an SQL statement.
SQL解释工具提供查询优化器为 SQL语句所选择的访问计划的有关详细信息。
In a statement from Boeing, 787 program manager Scott Fancher provides some carefully chosen words to explain the most recent schedule.
在波音的声明中,波音787计划的负责人斯科特范彻(Scott Fancher)字斟句酌,说明了本次公布的日程。
The statement came as something of a bombshell to the culture, sport and media select committee, which immediately announced it would be asking Murdoch to explain the contradiction.
这个爆炸性的声明传出以后,文化、体育和媒体委员会立即声明他们要请Murdoch解释其中的矛盾之处。
By then, he said, his team might be able to make a definitive statement about supersymmetry and some other theories to explain physics beyond the Standard Model.
他说,到那时,针对超对称性和一些连标准模型都无法很好解释的物理学,他的小组就能够提供一个具有权威性的说明了。
The EXPLAIN_FROM_CATALOG procedure produces explain information about a statement using the content of the section from the catalog tables.
EXPLAIN_FROM_CATALOG过程将使用目录表中的片段内容生成有关一条语句的解释信息。
Setting the AUTOTRACE option ON will enable the display of explain and statistics information for each statement executed in that session along with query results, until the AUTOTRACE is disabled.
将AUTOTRACE选项设置为ON 将允许显示该会话中执行的每条语句的说明和统计信息,以及查询结果,直至 AUTOTRACE 被禁用。
The SET EXPLAIN statement now supports an optional parameter to override the default name and location of the output file.
SETexplain语句现在支持一个可选的参数,用于覆盖输出文件的默认名称和位置。
There are slight differences between section explain and explain statement output in explain table and by the implications to the output generated by the db2exfmt utility.
片段解释和解释表中explain语句的输出与由db 2 exfmt实用工具生成的输出有一些差别。
The advantage of a section explain over a traditional explain using an explain statement is that the explain statement will recompile the statement being explained.
相对于使用explain语句的传统解释而言,片段解释的优势是explain会重新编译所解释的语句。
The results obtained after issuing a section explain are similar to those collected after running the explain statement.
执行一个片段解释所得到的结果与执行explain语句所收集的结果类似。
It reads the SQL statements executed from the event monitor tables and runs the Explain utility for each statement to generate the corresponding access plan.
它将读取从事件监控器表执行的sql语句,然后对每个语句运行Explain实用程序以生成对应的访问计划。
If the compilation environment or table statistics have changed when the explain statement is issued, the compiler may generate a different access plan.
如果编译环境或表统计信息在explain语句执行时已经发生改变,那么编译器可能会生成一个不同的访问计划。
Db2exfmt requires that an SQL statement has been previously explained into these tables, and formats the contents of the information in the explain tables.
db 2 exfmt需要已经将一条sql语句解释到这些表中,并设置explain表中信息内容的格式。
This would result in the maximum value for MATCHCOLS when doing an EXPLAIN on the SQL statement.
这样一来,当对sql语句进行EXPLAIN时,就可以产生最大的matchcols值。
To view the query access plan using the optimization profile created, the SET CURRENT optimization profile statement can be used in combination with the SET CURRENT EXPLAIN MODE statement, as follows.
要查看使用了创建的优化配置文件的查询访问计划,可以结合使用SETCURRENTOPTIMIZATIONprofile语句和SET CURRENTEXPLAINMODEstatement,如下所示。
A section explain is similar to the functionality provided by the db2expln command, but provides a level of detail approaching that provided by the explain statement.
片段解释在功能上与db 2 expln类似,但是在详细程度上更接近于explain语句。
This makes it possible to get query execution plan in the real production environment. To use this new feature, you need to use the key word AVOID_EXECUTE in SET EXPLAIN ON statement as follows
这使您可以在真正的生产环境中获取查询执行计划。
You owe it to your client to explain why no one cares about their mission statement on the homepage.
作为网页设计师,你有责任向客户解释过多的信息(如公司口号、使命陈述)既浪费空间又浪费注意力——尽管可能经理会在意它们,但事实上用户压根就不在乎。
There's only one statement there at the moment (which we'll explain shortly), but we could easily add more.
这里只有一条语句(我们很快解释),但我们可以很容易地添加多条语句。
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),就可以揭示大多数额外的处理(除了索引维护)。
In a statement, he quotes an old Chinese saying, "gold and jade on the outside, rot and decay on the inside," to explain his determination to smother his characters and sets with gold.
在一次发言里,他引用了中国的一句老话:“金玉其外,败絮其中,”以此来解释他为什么要把他的角色和场景层层裹上金装。
The next few sentences should explain your first statement, and prepare the reader for your thesis statement.
接下来的几句话应该开始陈述,让读者接受你的论点。
Explain the above statement with reference to a specific region.
以某一地区为例,解释以上的论点。
As another example, cash flow statement can also be used to explain where the net amount of cash flow that the business activities generate mainly comes from, and the cause for any variation.
再比如,通过现金流量表还可以了解到经营活动产生的现金流量净额主要来自于那里,其变化原因是什么。
Want train of thought not only when discuss clear, and should spread out in the round, after it is clear to explain theory explain theory first, contact again make relevant statement actually.
在论述时不仅要思路明晰,而且要全面展开,先把理论讲清楚后,再联系实际作相应的陈述。
Want train of thought not only when discuss clear, and should spread out in the round, after it is clear to explain theory explain theory first, contact again make relevant statement actually.
在论述时不仅要思路明晰,而且要全面展开,先把理论讲清楚后,再联系实际作相应的陈述。
应用推荐