因此让我们看一个示例查询应用程序。
在这种情况下,不能对这些查询应用静态SQL。
In such cases, static SQL cannot be applied to those queries.
确保MQT应用的谓词是查询应用的谓词的一个子集。
Make sure that the predicates applied by the MQT are a subset of the predicates applied by the query.
当然,在此例中,您希望查询应用于服务的某个部分的策略文档。
In this case, of course, you want to query policy documents that apply to a certain part of your service.
事实上,许多本地查询应用程序都要求用户通过两个输入框输入信息。
In fact, many local search applications ask the user for input in just this way via two input boxes.
目前,正在应用的面向即席查询应用的GIS系统不能满足企业运营要求。
At present, the existing GIS system that faces the extempore inquire can't meet the demand of the enterprises running.
在对外部查询应用惟一筛选器时可使用类似的技术,点符号将用于说明筛选结果所依据的字段。
A similar technique is used when applying the unique filter to the outer query, with dot notation used to indicate the field by which results are to be filtered.
MSFRP实现从特征层到语义层的多媒体数据检索,有效支持多媒体数据库的复杂查询应用。
MSFRP realizes multimedia data retrieving from character layer to semantic layer and supports sophisticated inquiry application of multimedia database efficiently.
批处理和查询应用程序通常要进行大量的顺序处理,而用于OLTP的数据访问往往更具有随机性。
Batch and query applications typically do a lot of sequential processing, while data access for OLTP tends to be more random in nature.
要查看性能是否还可以接受,您可能想对预期查询应用一些基本数学函数,当然,还要在您的环境中测试那些查询。
To see if performance is acceptable, you may want to apply some basic math to anticipated queries and, of course, test them in your environment.
在重写查询时,可以应用某些试探法。
跨多个数据源查询数据的应用。
可以使用此语法自己来查询样例应用程序。
You can use this syntax to query the sample application for yourself.
不可否认,转换和查询是涵盖许多应用的通用词。
Admittedly, transform and query are generic words that cover many applications.
那么我们如何在SQL查询的调优中应用那些工具呢?
正确定义好一个已命名的查询之后,应用程序就可以执行该查询并向返回的结果应用业务逻辑。
With a named query properly defined, the application can execute the query and apply business logic to the returned results.
对于具有短小、重复的查询的应用程序,建议这样做。
This is recommended for applications with short and repetitive queries.
用法:该参数控制何时向查询MDX应用NONempty子句的决策。
Usage: This parameter controls the decision on when the NON EMPTY clause is applied to the query MDX.
XQuery的一个特性是,能够指出您可以向其应用查询的特定文档。
A feature of XQuery is its ability to indicate a specific document to which you can apply a query.
Level仅仅决定查询算法应用于多少层。
Level simply determines how many layers the query algorithm is applied to.
下面的查询在该行中应用了xmlrow和xmlgroup函数。
The following query applies the xmlrow and xmlgroup function to this row.
查询2对authors表应用连接谓词。
通过在源属性和目标属性之间绘制RelationshipLookup转换,即可应用查询关系。
Lookup relationships are applied by drawing a relationship Lookup transformation between a source and target property.
应用程序需要查询属性类型。
再次运行测试客户端应用程序以查询和列出数据。
Run the test client application again to query and list the data.
运行测试客户端应用程序以查询和列出数据。
该信息允许快速识别模型和查询优化,应用该优化的目的是达到更好的性能。
This information permits the rapid identification of model and query optimizations which could be applied in order to achieve better performance.
只有在连接器能够将组合查询作为单一操作执行时,才应该应用组合查询。
Combined queries should only apply if your connector can execute the combined query as a single operation.
这样做的好处是,对副表的应用程序查询不需要修改,基于这些查询的大量应用程序逻辑也得以保留。
The advantage with this approach is that the application queries to the side tables do not change and much of the application logic based on them is preserved.
这样做的好处是,对副表的应用程序查询不需要修改,基于这些查询的大量应用程序逻辑也得以保留。
The advantage with this approach is that the application queries to the side tables do not change and much of the application logic based on them is preserved.
应用推荐