Certain heuristics can be applied in query rewrite.
在重写查询时,可以应用某些试探法。
Cardinality estimation is a process by which the optimizer USES statistics to determine the size of partial query results after predicates are applied or aggregation is performed.
基数估计是这样一种过程:在应用了谓词或执行了聚集之后,优化器使用统计信息确定部分查询结果的大小。
This information permits the rapid identification of model and query optimizations which could be applied in order to achieve better performance.
该信息允许快速识别模型和查询优化,应用该优化的目的是达到更好的性能。
In such a case, the graph pattern is applied to each of the named graphs available to the query.
在这种情况下,图形模式被应用到查询可以使用的每个命名图中。
Client applications can query a DAS and get a data graph in response, modify the data graph and send the updated data graph to a DAS to have the changes applied to the original data source.
客户机应用程序可以查询DAS并得到数据图表作为响应,修改数据图表并向DAS发送更新的数据图表,以便将这些更改应用到原始数据源中。
With this heuristic, predicates are applied as soon as possible (as close to table access as possible) in the query.
通过这种试探法,可以尽快(尽可能接近表访问)地在查询中应用谓词。
Make sure that the predicates applied by the MQT are a subset of the predicates applied by the query.
确保MQT应用的谓词是查询应用的谓词的一个子集。
This is a filter applied against a Query Subject.
这个过滤器适用于查询主题。
According to the overall query execution plan, the sub operations are then applied at the sources.
根据总体查询执行计划,将随后对数据源执行各个子操作。
Usage: This parameter controls the decision on when the NON EMPTY clause is applied to the query MDX.
用法:该参数控制何时向查询MDX应用NONempty子句的决策。
In this article, we will explore how the default data modes, default filter dialogs and default templates can be applied globally for all IBM Cognos Query Studio users.
在本文中,我们将探究如何为所有IBMCognosQueryStudio用户全局应用默认的数据模式、默认的过滤器对话框和默认的模板。
In reworking the Query Monitor course, we applied the DITA process model adapted for learning, as follows.
对QueryMonitor课程重新加工的过程中,我们采用针对学习调整的DITA过程模型,如后所述。
The "profile Information" section of the db2exfmt output can be used to verify that the correct optimization profile and statement profile have been applied to the current query.
db 2 exfmt输出的“ProfileInformation”部分可以用来检验是否已将正确的优化概要文件和语句概要文件应用到当前的查询。
In this article, we describe how we applied this DITA process model for learning to a case study course using content from an existing course on the IBM DB2 Query Monitor.
本文中,我们描述如何将这种学习DITA过程模型应用于一个示范课程,我们使用了现有的IBMDB 2QueryMonitor课程。
If Design filters are applied to both a fact query subject and any relating dimension query subjects, ensure that the filters are the same for both the fact and the related dimension.
如果DesignFilters应用到事实查询主题和任何相关的维度查询主题,要确保对事实和相关维度的过滤要一致。
As another example, the next query returns all PolicyAttachment objects that have been applied to a service starting with the name "IBM" (which is what we used in the earlier example for the element).
作为另一个示例,下一个查询返回所有已应用于以名称“IBM”开头的服务的PolicyAttachment对象(这就是我们在前面的示例中用于元素的查询)。
In order to obtain accurate results and provide the information pertinent to the business user the report manager has the ability to exercise fine control over the filters applied to each query.
为了获得准确的结果并提供与业务用户有关的信息,报表管理器能够对应用于每个查询的过滤器实施精细控制。
The technique described here can be applied to any database, provided the database has tools similar to DB2 for displaying and cancelling a given query.
这里所介绍的技术能适用于任何数据库,只要这个数据库使用类似于db2的工具来显示和取消一个给定查询。
The advantage of doing it this way rather than writing a query to handle it is that the business rules get applied via the UI so data integrity is ensured.
以这种方式代替编写查询并处理它的优势在于:业务规则通过UI得以应用,所以保证了数据完整性。
Finding out whether asynchrony optimization was applied to a particular query.
发现异步优化是否适用于特定的查询。
If the number of tuples, calculated by using the Cartesian product, exceeds the set threshold; the NON EMPTY clause is applied to the query.
如果通过使用Cartesian产品计算的元组数超过设定的阈值,将NONempty子句应用于查询。
Because user can use the method in object_oriented query language, it is already applied.
在面向对象查询语言中,因为用户可以使用方法,这种方法已经被应用了。
Level simply determines how many layers the query algorithm is applied to.
Level仅仅决定查询算法应用于多少层。
Assuming this filter is applied to the metadata for HWSystem that was defined in Listing 1, the code needed to perform this find by hostname query using the mediator would look like the following.
假定将此过滤器应用于清单1中定义的HWSystem的元数据,则通过中介执行该findbyhostname查询所需的代码如下所示。
The JAXBHandler, declared in Listing 10, is applied to each row in the result set of the SQL query.
清单10中声明的JAXBHandler应用于SQL查询结果集中的每一行。
Make sure that Redo Apply is running (so that the change is applied to the standby database). If the following query returns the MRP or MRP0 process, Redo Apply is running.
确保重做应用在运行,这样备库就会应用这些变化。如果以下的查询返回的MRP或者MRP0进程,则说明重做应用在运行。
Using NLU technology in the database query system and designing NLQID (natural language query interface of database) has become one of the most hopeful applied fields in the research on NLU.
在数据库查询系统中应用自然语言理解技术,设计数据库自然语言查询接口,已成为自然语言研究中最具有广泛应用前景的方向之一。
A query expression is processed by repeatedly applying the following translations in order. Each translation is applied until there are no more occurrences of the specified pattern.
查询表达式通过依次重复应用下述转换进行处理。每个转换被应用,直到不出现指定的模式为止。
The multilevel extension assessment method is applied to the shortest paths query system in the moving object databases.
将多级可拓评价方法应用于移动对象数据库中最优路径的查询系统。
The description of area-area spatial relations are enhanced by these metric parameters, and the parameters are widespread applied on spatial query and spatial analysis.
这些度量参数加强了面对象间空间关系的描述,可广泛应用于空间查询和空间分析中。
应用推荐