This will result in more accurate costing, and more optimal access plan.
这将导致更精确的成本计算和更优的访问计划。
Ensure those SQLs have optimal access plans and the best indexes in place.
确保那些SQLs拥有优化的访问计划和最佳索引。
This brings little overhead for compiling, but gives an optimal access plan.
这会增加一些编译负载,但却能够产生一个最优的存取计划。
The optimizer takes account of these changes and selects the optimal access plan when the job is executed.
而优化器会考虑这些变化,并且在作业执行时选择最佳访问计划。
We analyze the optimal access price in the asymmetric information by means of modern incentive theory.
本文利用现代激励理论分析了信息不对称情况下的输配电环节的最优接入定价问题。
Having the DBMS determine the optimal access path to the data lifts a heavy burden off the programmer's shoulders.
让DBMS确定到数据的最优存取路径解除了程序员肩上沉重的负担。
As you've seen in the steps above, the optimizer selects the optimal access plan based on available statistics.
您可以从以上步骤看到,这个优化器基于可用的统计信息选择了最优的存取计划。
Finally, the optimal access network was chosen through the weighted ranking of the relative membership degree.
最后,通过对相对隶属度的加权排序,得到最优接入网络。
Always use literals if the optimal access plan for the SQL statement varies according to the literals in the filter conditions.
如果sql语句的最优访问计划根据过滤条件中的文本变化,则应总是使用文本。
WebSphere Federation Server USES its cost based optimizer in order to determine the optimal access path to retrieve and process the data.
WebSphereFederationServer使用它的基于成本的优化器,确定检索和处理数据的最佳路径。
Ideally, the database will choose the most optimal access plan — that is, the plan that returns the data the most efficiently and quickly.
理想情况下,数据库将选择最佳访问计划——也就是能够最有效、最快地返回数据的计划。
If the SQL statement is badly coded, it is difficult for the optimizer to transform the query, leaving fewer options available for choosing an optimal access path.
如果sql语句设计得很糟,优化器就很难转换查询,在选择最佳访问路径时的选择就很少。
As we've discussed in this article, the DB2 optimizer may choose a sub-optimal access plan when there are host variables or parameter markers in the SQL statement.
正如我们在本文讨论的,如果sql语句中存在主机变量或参数标记,那么DB 2优化器可能会选择一个次优化的存取计划。
Legacy systems, performance, and other QoS attributes will tend to be constrained to use the most optimal access mechanism: whether pure services, hard-wired, or hybrid.
遗留系统、性能和其他QoS特性可能会阻碍使用最优的访问机制:不管是纯服务、硬编码连接或混合方法。
Without column data-value distribution information in the catalog, DB2 will assume an even distribution of values, which may lead the optimizer to a sub-optimal access path.
如果编目中没有列数据值分布信息,DB 2就会假设值是均匀分布的,这可能导致优化器选择非最优的访问路径。
However, if literals are important to get optimal access plans, the shorter execution times of the SQL statements are more important than the elegancy of the application's source code.
但是,如果文本对于获取最优访问计划很重要,那么更短的sql语句执行时间比应用程序源代码的优雅性更重要。
The first example implementation uses a technique where the initial design, as proposed by the standards used, suggests a non-optimal access pattern and causes performance problems.
第一个实例的实现使用的是最初的设计方法,由于是按标准使用模式提出的,表明它不是最佳的访问模式,因此会引起性能问题。
Ideally situated within the Canal District, a UNESCO World Heritage Site, the Pulitzer Amsterdam gives guests optimal access to all that the vibrant city of Amsterdam has to offer.
理想地坐落在运河区,联合国教科文组织世界遗产地,普利策·阿姆斯特丹为客人提供最佳的访问所有的充满活力的城市阿姆斯特丹。
Bandwidth is usually not a problem and execution and access time are optimal.
通常带宽不是问题,而且执行和访问时间也都是最佳的。
From the performance perspective, this is considered a very efficient join operation, because the cost for scanning the inner table is optimal via unique access through a unique index.
从性能的角度来看,这被认为是一个非常有效的联接操作,因为通过贯穿唯一索引的唯一访问扫描内部表的成本是最优的。
If stored procedures are used for data access, then these may well be optimal places to apply these rules.
如果将存储过程用于数据访问,则这些存储过程也是应用这些规则的最佳场所。
You can leverage the extended use of multi-column statistics in DB2 9.5 to provide the optimizer more information to better estimate the cardinality in order to choose an optimal query access plan.
您可以利用DB2 9.5 中的多列统计信息的扩展用途来为优化器提供更多的信息,从而使优化器更好地估计基数,选择最佳的查询访问计划。
Ideally, the database chooses the most "optimal" access plan — that is, the plan that returns the data most efficiently and quickly.
在理想情况下,数据库会选择最“优化”的访问计划——也就是最高效最快地返回数据的计划。
In this case, the optimizer creates a different access plan, which may not be optimal if the user input is 0.
在这种情况下,优化器会创建的存取计划都是不一样的,这在用户输入为0时可能不是最优的。
If the cost estimatd does not correctly describe the real cost during SQL execution, the access plan picked by the optimizer may not be optimal.
如果评估得到的开销不能够正确反映SQL执行中的实际开销,那么优化器所选择的存取计划可能不是最优的。
Given the optimal execution time, reducing access time is another concern for developers.
如果给定最佳的执行时间,则减少访问时间是开发人员需要关心的另一个问题。
When a web service request is simple, the time to access the requested information from a database or another source must be optimal.
当Web服务请求比较简单时,从数据库或者另外的数据源中访问所请求的信息的时间必须是最佳的。
A variety of disk hardware combinations are possible, and Linux doesn't always reliably detect the optimal way to access the disks.
有多种磁盘硬件组合,而且Linux不一定能够探测出访问磁盘的最佳方式。
Select a query and click Tune to transfer the query to IBM Data Studio to format the query, analyze the access plan, or check whether statistics are current and optimal.
选择一个查询并单击Tune 可将其转化为IBMDataStudio,来格式化查询、分析访问计划、或者检查统计是否存在且最优。
Select a query and click Tune to transfer the query to IBM Data Studio to format the query, analyze the access plan, or check whether statistics are current and optimal.
选择一个查询并单击Tune 可将其转化为IBMDataStudio,来格式化查询、分析访问计划、或者检查统计是否存在且最优。
应用推荐