... Logon to Online Service System 注册到联机服务系统 Explain an SQL statement 匹配码对象(测试) Setups/Tune Buffers 设置/调谐缓冲 ...
基于20个网页-相关网页
The SQL explain facility provides detailed information about the access plan that the query optimizer chooses for an SQL statement.
SQL 解释工具提供查询优化器为 SQL 语句所选择的访问计划的有关详细信息。
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值。
应用推荐