The next step is query rewrite (QRW) optimization.
下一步是查询重写(QRW)优化。
Certain heuristics can be applied in query rewrite.
在重写查询时，可以应用某些试探法。
Example 5: INLIST to Nested Loop Join (query rewrite).
例子5：INLIST改为嵌套循环连接(查询重写)。
Here's one more query rewrite idea: if possible, remove column expressions in predicates to make the predicates indexable.
这里还有一个查询重写思想：如果可能的话，删除谓词中的列表达式确保谓词是可索引的。
The optimization of SQL queries utilize sophisticated features, such as: query rewrite, multiple join methods, detailed statistics, parallelism etc.
SQL查询的优化利用了一些复杂的功能，例如：查询重写、多连接(join)方法、详细的统计、并行性等。
Besides query optimization, another efficient way is query rewrite using materialized views.
除了对查询进行优化外，另外一种方式就是用物化视图改写查询。
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来摆脱一个范围型谓词，可以通过提高索引键列匹配增强性能。
The following examples are demonstrative of optimization profiles usage in 3 categories, namely, general optimization, query rewrite, and plan optimization.
下面的例子演示了优化概要文件在3类情况下的使用，即常规优化、查询重写和计划优化。
The following examples are demonstrative of optimization profiles usage in 3 categories, namely, general optimization, query rewrite, and plan optimization.
下面的例子演示了优化概要文件在3类情况下的使用，即常规优化、查询重写和计划优化。
应用推荐