将丰富的业务逻辑构建到存储过程和高性能查询中的企业，现在可以使用DWS立即将它们放到SOA环境中。
Enterprises that have built rich business logic into their stored procedures and high-performance queries now have the capability to instantly make them available in an SOA environment using DWS.
您将注意到随着您的集合增长查询性能将会降低。
You'll notice as your collections grow that query performance will degrade.
在数据源上的远程表上定义索引有时候可以提高查询性能。
Defining indexes on the remote table on the data store might sometimes improve query performance.
创建恰当的索引将提高查询的性能。
Creating proper indexes improves the performance of the query.
不能下推的函数和操作会大大影响查询的性能。
Functions and operations that cannot be pushed down can greatly impact query performance.
该特性可以提高具有复合索引的表的查询性能。
This feature can improve query performance on tables with composite indexes.
本节阐释每个分区特性对查询执行性能的作用。
This section illustrates how each partitioning feature contributes to the performance of query execution.
这个简单的步骤可能产生新的访问路径，可能显著改进查询性能。
That simple step could lead to a new access path that might dramatically improve query performance.
下面是用于调优联邦查询性能的众多方法中的一种。
The following is one of many approaches to tuning federated query performance.
SQL编译器使用信息约束来提高查询性能。
The SQL compiler uses informational constraints to improve query performance.
本文还介绍了潜在的查询性能问题以及如何解决这些潜在问题的方法。
This article describes a methodology for understanding potential query performance problems and how to address those potential problems.
这种异步可以显著提高查询的性能。
This asynchrony can lead to significant improvements in query performance.
您将发现这个方便的实用程序可用于调试问题和提高查询性能。
You'll find this a handy utility for debugging problems and improving query performance.
通常，使用索引可以改善查询性能。
外部连接可能会对查询性能产生负面影响。
Outer joins may have a negative impact on query performance.
一个缓冲池可满足的页面请求越多，将得到越高的查询性能。
The more page requests that can be satisfied by a buffer pool, the better query performance will be.
此外，xml索引和关系型索引的组合使用还可以进一步提高查询性能。
Additionally, a combination of XML indices and relational indexes can further improve query performance.
管理员可以分析并使用这些信息来增强搜索性能或查询结果的质量。
The administrator can analyze and use this information to enhance search performance or the quality of search results.
这通常会提高查询性能。
由于规划日志很大，在启用该设置时可能会影响查询性能。
Since planning logs are large, there may be an impact on query performance when this setting is enabled.
索引能够避免全表扫描，从而能够提高查询性能。
Indexes improve query performance by avoiding a full table scan.
利用这些特性，即可显著缩短处理一个性能较差的查询时的分析时间。
By using these features, it can greatly reduce investigation time when dealing with a poor-performing query.
可以在MQT上定义索引，这会进一步提高查询性能。
An MQT can be indexed to provide an even greater boost to query performance.
随着数据集不断变大，查询性能愈发变得重要。
As datasets grow larger, query performance becomes increasingly important.
这类索引有助于改善针对空间数据的查询的性能。
Such indexes help to improve the performance of queries on spatial data.
异步可以显著提高联邦查询的性能。
Asynchrony can significantly improve the performance of federated queries.
在分解性能、查询性能以及报告和分析的容易程度等方面，每种方式都有不同的优点和缺点。
Each has different advantages and disadvantages, related to shredding performance, query performance, and the ease of reporting and analytics.
通过这个编辑器，您也能够访问可以协助分析和优化SQL查询性能的IBM工具。
Through the editor, you can also access IBM tools that help you analyze and tune the performance of your SQL queries.
数据库索引对于查询性能来说十分关键。
进行了修改之后，如果查询性能没有优于您原始查询的，就撤销修改。
If after making the change, the performance of your query is not better than your original query, reverse the change.
应用推荐