Certain heuristics can be applied in query rewrite.
在重写查询时，可以应用某些试探法。
Rewrite is an optimization strategy that transforms a valid query into a semantically equivalent form that can be more efficient to execute.
重写是一种优化策略，它将一个有效的查询转化成语义上相等的一种新形式，这种新的形式执行起来更为高效。
The following examples are demonstrative of optimization profiles usage in 3 categories, namely, general optimization, query rewrite, and plan optimization.
下面的例子演示了优化概要文件在3类情况下的使用，即常规优化、查询重写和计划优化。
The next step is query rewrite (QRW) optimization.
下一步是查询重写(QRW)优化。
The final equivalent query after the rewrite transformation is shown below.
经过重写变换之后得到的等效的查询如下所示。
Here's one more query rewrite idea: if possible, remove column expressions in predicates to make the predicates indexable.
这里还有一个查询重写思想：如果可能的话，删除谓词中的列表达式确保谓词是可索引的。
This advisor makes recommendations on how to rewrite a query to enhance efficiency based on bestpractice rules.
这个建议器根据最佳实践为重写查询提供建议，帮助提高效率。
External optimizer directives are useful when it is not feasible to rewrite a query for a short-term solution to a problem, for example, when a query starts to perform poorly.
在使用改写查询作为问题的短期解决方案不可行的时候，比如查询的执行效率很低的时候，外部优化器指令可能很有用。
When you select a recommendation, the line of SQL is highlighted, and you are presented with a description of how to rewrite the query, as well as an explanation of the recommendation (see Figure 1).
当选择一个建议时，突出显示sql行，显示对如何重写查询的说明以及对建议的解释(见图1)。
Q2 is the rewritten table name by the query rewrite.
Q2是该查询改写的表名。
In addition, for some queries, the optimized SQL (this is the output of query rewrite) in the db2exfmt output shows use of an MQT instead of base nicknames.
此外，对于某些查询，db 2 exfmt输出中优化的SQL(这是查询重写的输出)展示了MQT的使用而非基本昵称。
The optimization of SQL queries utilize sophisticated features, such as: query rewrite, multiple join methods, detailed statistics, parallelism etc.
SQL查询的优化利用了一些复杂的功能，例如：查询重写、多连接(join)方法、详细的统计、并行性等。
Example 5: INLIST to Nested Loop Join (query rewrite).
例子5：INLIST改为嵌套循环连接(查询重写)。
Yes, you could come up with a complex scheme to rewrite your users' query so it searches across all of the known fields, but remember, keep it simple.
是的，你能提出一个复杂的方案重写你的用户请求让它搜索所有的已知Field，但记住，保持简洁。
To retrieve all elements, you need to rewrite the query.
为了检索所有元素，需要重新编写该查询。
Also in the query rewrite vein, modifying a SELECT to get rid of a range-type predicate can increase performance by improving index key column matching.
另外，在查询重写状态下，修改SELECT来摆脱一个范围型谓词，可以通过提高索引键列匹配增强性能。
DB2 can automatically rewrite a query to take advantage of an MQT.
DB 2可以自动地重写查询以使用MQT。
The query compiler performs two major categories of rewrite
查询编译器主要可以执行两种类型的重写
This is due to the query rewrite renaming the tables. Look at the optimized statement.
这是因为查询对表重新命名了。
One rewrite a query on the global ontology to queries on the local ontology, the other rewrite a query on the local ontology to queries over the data sources.
算法一将用户提出的对全局本体的查询转化为对局部本体的查询，算法二将对局部本体的查询转化为对数据源的查询。
In the integration server layer, design a query optimizer and research query rewrite, cost estimation model and caches mechanism.
在服务器层设计一个查询优化器，并研究了查询重写和代价估计优化方法以及缓存机制。
Besides query optimization, another efficient way is query rewrite using materialized views.
除了对查询进行优化外，另外一种方式就是用物化视图改写查询。
Besides query optimization, another efficient way is query rewrite using materialized views.
除了对查询进行优化外，另外一种方式就是用物化视图改写查询。
应用推荐