对于翁达杰先生来说,写作本身很容易,大多数工作是整理和重写语句。
Words come easily for the author — the bulk of the work is arranging and rewriting sentences.
接着,该语句要经过一个重写阶段。
重写阶段会检测这些冗余,并简化语句。
The rewrite phase detects these and simplifies the statement.
要实现访问计划重用,使用一个参数标记重写SQL语句,如 清单3 所示。
To enable access plan reuse, rewrite the SQL statement using a parameter marker, as shown in Listing 3.
使用SETTRANSACTIONpassthrough和SET passthrough语句,可以在每个会话或每个事务中重写在配置文件中指定的默认SQL passthrough模式。
The default SQL passthrough mode that is specified in the configuration file can be overridden per session or per transaction using the SET transaction passthrough and SET passthrough statements.
重写后的查询也称为“OptimizedSQL”,它将在使用db2exfmt命令解释语句时出现。
The rewritten query known as "Optimized SQL" is visible when you explain the statement with the db2exfmt command.
通过将set语句嵌入CASE表达式中,重写CASE和IFTHENelse语句。
Rewrite CASE and IF THEN ELSE statements with embedded SET statements into CASE expressions.
通常重写一个低效的SQL语句比修改它要简单。
Often, rewriting an inefficient SQL statement is easier than modifying it.
查询处理包括全局查询语句解析、查询变量绑定、查询分解和查询重写。
Query processing contains parsing of global query, binding of query variable, decomposition of query and rewriting of query.
PDO并不提供数据提取,它不会重写SQL语句,或者模仿这些功能。
PDO does not provide a database abstraction; it doesn't rewrite SQL or emulate missing features.
PDO并不提供数据提取,它不会重写SQL语句,或者模仿这些功能。
PDO does not provide a database abstraction; it doesn't rewrite SQL or emulate missing features.
应用推荐