To improve performance, federation frequently USES caching, materialized query tables (MQTs), and distributed query optimization and execution.
要改进性能,联合需要经常使用缓存、物理查询表(MQT)以及分布式查询优化和执行。
The following shows how an optimization guideline can specify the runtime degree for a query and affect the query execution.
下面的代码展示了优化指南如何为查询指定运行时等级以及如何影响查询的执行。
The optimizer considers star join optimization when appropriate and decides on star join plan based on cost considerations in order to come up with best execution plan for a star join query.
为了实现星型连接查询的最佳执行计划,优化器在适当的时候会考虑星型连接优化,并根据成本因素来决定星型连接计划。
For example, modeling for business requirements, modeling for business optimization, and modeling for execution will require different sets of knowledge and skills, and perhaps additional tools.
例如,业务需求的建模、业务优化的建模和执行的建模将需要不同的知识和技能,或许还需要其他工具。
For the exceptional situations where the optimizer cannot choose an optimal query execution plan, DB2 has added features such as the SELECTIVITY clause and optimization guidelines.
对于优化器不能选择最佳查询执行计划的例外情况,DB 2已经增加了诸如selectivity子句和优化指南之类的特性。
The execution engine behind it knew how to execute those operations and it even had an explicit optimization step designed to reduce the calculations necessary to yield a result.
它背后的执行引擎知道如何执行那些操作,它甚至有一个显式的优化步骤,以减少获得结果所需的计算。
Client optimization captures SQL from executing applications and enables administrators to bind the SQL to DB2 for static execution without changing a single line of application code.
客户端优化从执行中的应用程序捕捉SQL,使管理员能够将SQL绑定到DB 2实现静态执行,并且不需要更改应用程序的代码。
On-Demand Router (ODR), part of Operations Optimization, provides a goals-oriented execution environment, dynamic provisioning of server resources, and health management.
按需路由器(odr, on - Demand Router)是OperationsOptimization的组成部分,可以提供面向目标的执行环境,动态地提供服务器资源和运行状态管理。
Experiment shows that this optimization code can improve system's performance and reduce the execution time to 50%.
实验表明,经上述方法优化后的目标代码,执行效率提升了近50%,有效地提高了系统性能。
Convergence, Objective Vector and Active Constraint Set Monitoring during Optimization Execution, Multivariable Plotting Techniques: Radar Plots, Carpet Plots and Glyphs.
执行最优化过程中的收敛,目标向量和活动约束集的监视,多变量绘图技术:雷达绘图、地毯绘图和浮雕绘图。
Like the testing flow of other softwares, the main issues in compiling optimization testing include test case generation, test case execution and test result analysis, etc.
编译器测试的主要流程和通常的软件测试一样,包括了测试用例生成、测试用例执行以及测试结果判定等活动。
Experimental results show that the scheme has ability to improve significant performance significantly, and predict the application's execution time after optimization with a maximum error of 2%.
实验结果表明,该策略能够显著提高程序性能,平均提高一倍,甚至更高,同时它能够预知优化后程序执行时间的变化,最高误差为2%。
After normalization and optimization are completed, the normalized tree produced by those processes is compiled into the execution plan, which is actually a data structure.
在规范化树和优化结束之后,其生成的规范化树将被引用并编译到执行计划中,执行计划实际上就是一种数据结构。
This paper introduces an optimization of Advanced Encryption Standard (AES) with 128-bit block length and key length. It can speed up execution on ARM microprocessor.
提出一种高级加密标准(aes)算法的优化方案,适合在ARM处理器上运行长度均为128位的明文和密钥。
This paper introduces an optimization of Advanced Encryption Standard (AES) with 128-bit block length and key length. It can speed up execution on ARM microprocessor.
提出一种高级加密标准(aes)算法的优化方案,适合在ARM处理器上运行长度均为128位的明文和密钥。
应用推荐