将丰富的业务逻辑构建到存储过程和高性能查询中的企业,现在可以使用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.
这样通常可以提高查询的性能。
如上所述,性能是查询调优中主要关心的问题。
As stated above, performance is the major concern in query tuning.
您将注意到随着您的集合增长查询性能将会降低。
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.
取决于表的大小和网络的传输情况,查询性能可能会很糟糕。
Depending on the size of the table and network traffic, query performance could suffer.
创建恰当的索引将提高查询的性能。
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.
数据仓库数据库设计的重点在于查询性能。
The design of a data warehouse database is focused on query performance.
这种异步可以显著提高查询的性能。
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.
管理员可以分析并使用这些信息来增强搜索性能或查询结果的质量。
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.
可以在MQT上定义索引,这会进一步提高查询性能。
An MQT can be indexed to provide an even greater boost to query performance.
该查询的性能并不好。
随着数据集不断变大,查询性能愈发变得重要。
As datasets grow larger, query performance becomes increasingly important.
异步可以显著提高联邦查询的性能。
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.
性能方面的改进包括查询性能和恢复时间的提高。
The performance enhancements include improved query performance and recovery time.
应用推荐