Provides an overview of federated query optimization.
对联邦查询优化作一个概述。
This will have an undesirable effect on query optimization.
这对于查询的优化有着不良的影响。
This section covers query optimization and schema optimization.
这一部分包含了查询优化及方案优化。
This will have an undesirable effect on query optimization .
这对于查询的优化有着不良的影响。
Informational constraints can be a great aid to query optimization.
信息约束可以很好地辅助查询优化。
Meanwhile, query optimization tactics focused on minimizing page fetches wherever possible.
与此同时,查询优化策略注重尽可能减少页面读取。
You can defer query optimization until input variables are known at runtime with the REOPT guideline.
可以使用REOPT指南,将查询优化推迟到运行时输入变量已知的时候。
The REOPT bind option defers query optimization until input variable values are available at OPEN time.
REOPT绑定选项将查询优化推迟到OPEN时有可用输入变量的时候。
Large buffer pools also have an effect on query optimization, since more of the work can be done in memory.
大型缓冲池还会对查询优化产生影响,因为更多的工作可在内存中完成。
The RUNSTATS utility updates statistics in the system catalog tables to help with the query optimization process.
RUNSTATS实用程序用于更新系统目录表中的统计信息,以帮助查询优化过程。
REOPT once: query optimization occurs once at query execution time, when the query is executed for the first time.
REOPT ONCE:查询执行中只发生一次查询优化,即在查询第一次执行时。
Now let us discuss the issue with the query optimization for the objects which are configured for second level cache.
现在我们来谈谈关于二级缓存的查询优化问题。
New query language support (for XQuery), a new graphical query builder (for XQuery), and new query optimization techniques.
新查询语言支持(针对Xquery)、新图形查询构建程序(针对Xquery)和新查询优化技术。
The federation server must also provide query optimization capabilities in order to respond to the request most efficiently.
联合服务器还必须提供查询优化功能,以最高效地响应请求。
The runstats utility can be used to update statistics in system catalog tables to facilitate the query optimization process.
可以使用runstats实用程序来更新系统编目表中的统计信息,使查询优化过程更容易一些。
The query optimization class is used to direct the optimizer to use different degrees of optimization when compiling SQL queries
查询优化类用于在编译SQL 查询时指导优化器使用不同的优化级别。
XML indexing, query optimization, storage management, and other DB2 services help ensure efficiency and strong runtime performance.
xml索引、查询优化、存储管理和其他DB 2服务有助于确保出色的效率和运行时性能。
The value of the register in turn determines what types of refresh deferred materialized query tables will be used during query optimization.
注册表的值又确定在查询优化期间将使用何种类型的刷新延迟物化查询表。
To improve performance, federation frequently USES caching, materialized query tables (MQTs), and distributed query optimization and execution.
要改进性能,联合需要经常使用缓存、物理查询表(MQT)以及分布式查询优化和执行。
An operator class is used in conjunction with the access method to specify the operators used for building the index and during query optimization.
将操作符类与访问方法结合使用,可以指定创建索引和优化查询时使用的操作符。
The discussion focused on a couple of big issues of database design without getting into the details of query optimization and application considerations.
本文着重讨论了数据库设计的两个比较大的问题,而没有深入研究查询优化和应用程序考虑事项的细节。
For statistical view, the ENABLE query optimization clause will cause the view, and its associated statistics to be used to improve the query optimization.
对于统计视图,ENABLEQUERY optimization子句将导致该视图以及与之相关联的统计信息被用于改进查询优化。
Therefore, most implementations of the data federation pattern focus less on complex transformation capabilities and more on query optimization technologies.
因此,大部分数据联合模式的实现对复杂转换功能的关注相对较少,而更强调查询优化技术。
The SQL compiler USES query optimization to select the best performing access path for any given SQL statement (within a reasonable amount of time, of course).
SQL编译器使用查询优化来为任何给定的sql语句选择表现最好的访问路径(当然,这要在合理的时间内)。
Database query optimization for some of the APIs' operations like querying business process and task related objects (usage of materialized views or stored queries) (see the Resources section).
针对某些API操作(如查询与业务流程和任务相关的对象)的数据库查询优化(使用物化视图或存储查询)(请参见参考资料部分)。
Query optimization features using hints, explain plans, and profiling.
使用提示、解释计划和分析的查询优化特性。
Query optimization concerns how to improve the performance of slow queries.
查询优化涉及到了怎样改进慢速查询的问题。
Query optimization is crucial in dealing with databases, and UPDATE STATISTICS does just that.
在处理数据库时,查询优化至关重要,而UPDATESTATISTICS正是用于此目的。
The 'DISABLE QUERY OPTIMIZATION' clause may be used to prevent the optimizer from considering use of a particular MQT.
DISABLEQUERY OPTIMIZATION'子句可以用来防止优化器考虑使用特定的MQT。
Query optimization technology in DB2 9.7 provides increased efficiency for processing queries against relational views of XML data.
DB 2 9.7中的查询优化技术能够提高针对XML数据的关系视图的查询处理效率。
应用推荐