可以为每个搜索查询重写此参数。
下一步是查询重写(QRW)优化。
例子5:INLIST改为嵌套循环连接(查询重写)。
基于视图的查询重写技术是优化查询的一个重要技术。
Query rewriting technology based on view is an important technology of the query optimization.
并给出了一个RDF语义查询包含算法和查询重写算法。
The algorithms for RDF-based query subsumption inference and query rewriting are also introduced.
查询规划系统由查询分析器和查询重写器这两大部分构成。
This query planning system has two components: query Analyzer and query Rewriter.
LinQ的实现策略包括了根据提供者来把查询重写成API调用。
The implementation strategy for LinQ involves rewriting the query into API calls against a provider.
在聚类和非一致性数据库无聚集查询基础上提出聚集查询重写方法。
This paper presents the rewriting method for aggregation queries based on clusters and non-aggregation queries in inconsistent databases.
查询处理包括全局查询语句解析、查询变量绑定、查询分解和查询重写。
Query processing contains parsing of global query, binding of query variable, decomposition of query and rewriting of query.
下面的例子演示了优化概要文件在3类情况下的使用,即常规优化、查询重写和计划优化。
The following examples are demonstrative of optimization profiles usage in 3 categories, namely, general optimization, query rewrite, and plan optimization.
这里还有一个查询重写思想:如果可能的话,删除谓词中的列表达式确保谓词是可索引的。
Here's one more query rewrite idea: if possible, remove column expressions in predicates to make the predicates indexable.
在服务器层设计一个查询优化器,并研究了查询重写和代价估计优化方法以及缓存机制。
In the integration server layer, design a query optimizer and research query rewrite, cost estimation model and caches mechanism.
另外,在查询重写状态下,修改SELECT来摆脱一个范围型谓词,可以通过提高索引键列匹配增强性能。
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.
SQL查询的优化利用了一些复杂的功能,例如:查询重写、多连接(join)方法、详细的统计、并行性等。
The optimization of SQL queries utilize sophisticated features, such as: query rewrite, multiple join methods, detailed statistics, parallelism etc.
首先提出了一个利用映射信息(映射图)将带正则路径表达式的XML查询重写为一组简单路径查询的算法。
At first, an algorithm is proposed, which rewrites a regular path expression based XML query as a group of simple path expression based queries using mapping information (mapping graph).
主要论述OVSR的本体架构,视频语义模型和索引模型,研究OVSR的查询重写算法以及本体推理算法。
The authors mainly discussed OVSR's ontology structure, video semantic model and indexing model, and studied the user's searching rewriting algorithm and ontology reasoning algorithm.
此外,对于某些查询,db 2 exfmt输出中优化的SQL(这是查询重写的输出)展示了MQT的使用而非基本昵称。
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.
研究了聚集查询重写的特征,根据数据仓库环境下聚集查询需要快速计算结果的特点,给出了一个基于聚集查询重写的快速近似计算模型。
This paper researches into the characteristic of aggregate query rewriting and gives a kind of rapidly approximate query computing model based on aggregate query rewriting under the data warehouse.
为了减少在计算和存档数据流的过程中对昂贵的存档数据的存取,分析了聚集数据查询的特点,并引入了聚集查询语言和聚集查询重写方法。
To reduce the expensive access to archive data, the characteristics of aggregate data query were analyzed, and the aggregate query language and its rewriting method were proposed.
在重写查询时,可以应用某些试探法。
这个已重写的查询现在如图10 所示。
经过重写变换之后得到的等效的查询如下所示。
The final equivalent query after the rewrite transformation is shown below.
这个建议器根据最佳实践为重写查询提供建议,帮助提高效率。
This advisor makes recommendations on how to rewrite a query to enhance efficiency based on bestpractice rules.
重写是一种优化策略,它将一个有效的查询转化成语义上相等的一种新形式,这种新的形式执行起来更为高效。
Rewrite is an optimization strategy that transforms a valid query into a semantically equivalent form that can be more efficient to execute.
当查询被提交到DB 2后,将以一种最适合优化的方式重写它。
When a query is submitted to DB2, it is rewritten in a form that is most suitable for optimization.
下面的例子演示了重写阶段如何提高对unionALL视图的某些类型的查询,以取得更好的性能。
The following is an example demonstrating how the rewrite phase can enhance certain types of queries against UNION ALL views to achieve better performance.
当选择一个建议时,突出显示sql行,显示对如何重写查询的说明以及对建议的解释(见图1)。
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。
If necessary, you can experiment with rewriting the query to see how it affects the optimized SQL.
重写长时间查询是另外一个无需添加索引即可增强性能的方法。
Rewriting long-running queries is another way to boost performance without adding indexes.
DB 2可以自动地重写查询以使用MQT。
DB2 can automatically rewrite a query to take advantage of an MQT.
应用推荐