The last section discussed how to apply filter predicates at the database level to improve query performance and response times.
最后一节讨论如何在数据库级应用过滤谓词,以提高查询性能和缩短响应时间。
This can improve query performance in general.
这样通常可以提高查询的性能。
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.
不能下推的函数和操作会大大影响查询的性能。
As stated earlier, we used direct JDBC calls for our complex query operations to avoid the performance overhead in EJB2 query.
如前所述,对于复杂的查询操作,我们使用了直接JDBC调用,从而避免EJB 2查询中的性能开销。
Data clustering can have an especially large impact on data warehouse query performance, because rows are often retrieved in large Numbers.
数据聚簇对于数据仓库查询性能的影响尤其显著,因为常常在一个查询中获取许多行。
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.
下面是用于调优联邦查询性能的众多方法中的一种。
Can you replace useless indexes with indexes that enhance query performance?
你可以使用增强性能的索引替换无用索引吗?
The SQL compiler uses informational constraints to improve query performance.
SQL编译器使用信息约束来提高查询性能。
This article describes a methodology for understanding potential query performance problems and how to address those potential problems.
本文还介绍了潜在的查询性能问题以及如何解决这些潜在问题的方法。
Understanding data flow is important because it is the most influential factor in terms of the query performance aspect of query execution.
了解数据流很重要,因为就查询执行的查询性能方面来说,这是最有影响力的因素。
The performance of the query workload increased as the number of users increased and the CPUs were better utilized.
查询工作负载的性能随着用户数量的增加和更好地利用CPU 而增加。
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.
您将发现这个方便的实用程序可用于调试问题和提高查询性能。
Indexes are commonly used to improve 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.
一个缓冲池可满足的页面请求越多,将得到越高的查询性能。
This includes section data, values, actuals, etc, which are crucial during investigating a query performance issues.
这其中包括片段数据、值、实绩等,这对于研究一个查询的性能问题是至关重要的。
Additionally, a combination of XML indices and relational indexes can further improve query performance.
此外,xml索引和关系型索引的组合使用还可以进一步提高查询性能。
This typically results in better query performance.
这通常会提高查询性能。
It's pointed out that a major design element for performance is the query cache.
需要指出的是关于性能的主要设计要素是查询缓存。
Performance of this query will not be good.
该查询的性能并不好。
Each has different advantages and disadvantages, related to shredding performance, query performance, and the ease of reporting and analytics.
在分解性能、查询性能以及报告和分析的容易程度等方面,每种方式都有不同的优点和缺点。
应用推荐