optimizer

  • 网络优化器;优化程序;查询优化器

optimizeroptimizer

optimizer

优化器

优化器(Optimizer)的开发人员几乎都走了,他们去了MontyAB。至于复制(Replication)功能,除了第一版的编写者之外,其他 …

优化程序

求计算机专业英语词汇_百度知道 ... optimize synchronization 优化同步 optimizer 优化程序 ordered set 有序集 ...

查询优化器

查询优化器(Optimizer) 查询优化器以Schema Object的统计程度,考虑各种数据处理路径,决定何种运行计划最有效率。 查询 …

代码优化器

Zend公司开发的一套给PHP加速的东西,包括一个代码优化器(optimizer)和一个加速器(accelerator)mod-security http://www.mo…

优化器组件

·优化器组件(Optimizer)。 ·缓冲组件(Caches & Buffers)。

优化工具

图5-1 优化工具Optimizer)的工作流程 图中: 1.设置电路图(与第4 章相同); 2.调用PSpice 进行电路特性模拟(与第4 …

电路优化程序

电路仿真... ... 第7章 激励源编辑程序— Stimulus Editor 第8章 电路优化程序Optimizer 第10章 电路文件编辑程序— Text Edito…

最佳化器

并利用最佳化器Optimizer) 将无资料相关(Data dependence)之指令移来,取代此NOP 指令。此法可减少程式之长度,但 …

1
Due to the interplay of these diverse independent factors, in rare instances, the optimizer might select less than optimal execution plans. 在这些不同的独立因素的相互作用下,优化器可能会选择不太优化的执行计划。
2
Ideally, the optimizer would identify the most efficient access plan possible, but this goal is often impractical. 在理想情况下,优化程序将尽可能地找出最为高效的访问计划,但这一目标通常是不切实际的。
3
Note, however, that the optimizer is often unable to precisely estimate a query's cost, so expect there to be differences. 但是,请注意,优化程序通常无法精确地预计查询的成本,因此应该会存在差异。
4
The output of the optimizer is a query execution plan, sometimes referred to as a query plan or just a plan. 优化器的输出称为“查询执行计划”,有时也称为“查询计划”或直接称为“计划”。
5
You can use the REWRITE function without the ANSI argument to help understand how the optimizer generated the access plan for a given query. 使用REWRITE函数时可以不带ANSI参数,这样可以帮助理解优化程序是如何生成给定查询的访问计划的。
6
No degree of query optimizer intelligence can eliminate the resource cost of these constructs when compared to a less complex query. 与不太复杂的查询相比,查询优化器的智能水平无法消除这些构造的资源开销。
7
The optimizer's estimate could be very close to the actual value as long as the data distribution has not changed since the last RUNSTATS. 只要数据分布自上一次RUNSTATS以后没有改变,则优化器的估计可能非常接近实际值。
8
Further, the solidDB query optimizer recognizes the different nature of the in-memory tables by estimating execution costs in a new way. 而且,solidDB查询优化器通过以一种新的方式估计执行成本,判别内存中的表的不同性质。
9
It is possible that the query optimizer might have generated a remote statement that hits the remote server's limitation on performance. 查询优化器有可能生成与远程服务器的性能限制有冲突的远程语句。
10
Predicates with concrete values are important for the optimizer to be able to use available distribution statistics. 为使优化器能够使用可用的分布统计信息,带有具体值的谓词极为重要。
11
If the execution plan problems cannot be avoided, guidelines can be used to affect the optimizer plan to mitigate the performance problems. 如果无法避免执行计划中出现的问题,那么可以使用准则来影响优化器计划,从而解决性能问题。
12
The optimizer uses MAGIC values as a last resort when it is unable to accurately predict the selectivity of a predicate . 当优化程序不能准确判定一个谓词的选择性时,它的最后一个手段就是利用MAGIC值。
13
Many customers new to Informix do not realize they must update statistics, and see poor performance due to the lack of optimizer statistics. 许多Informix新客户没有认识到他们必须更新统计数据,因此由于缺少最新的优化器统计数据,他们的数据库性能很差。
14
An entry is added to the system catalog to indicate to the query optimizer that such a remote index exists. 一个条目被添加到系统编目中,以向查询优化器表明存在那样的一个远程索引。
15
Up-to-date statistics allow the optimizer to accurately assess the cost of different query plans, and choose a high-quality plan. 最新的统计信息允许优化器准确地估计不同查询计划的开销,并选择高质量的计划。
16
If the best indexes do not exist, the query optimizer generates a suboptimal query plan, but still stores information about these indexes. 如果不存在最佳索引,则查询优化器将生成非最佳查询计划,但会存储有关这些缺失的最佳索引的信息。
17
The optimizer depends on accurate cardinality estimates to properly compute the cost of each query access plan considered. 优化器凭借精确的基数估计值来准确计算出每一个待定查询访问计划的成本。
18
db2exfmt is typically used for comprehensive performance analysis, as it provides the most optimizer information. db2exfmt通常用于广泛的性能分析,因为它提供了大部分优化器信息。
19
Information returned by sys. Dm_db_missing_index_details is updated when a query is optimized by the query optimizer, and is not persisted. 由sys.dm_db_missing_index_details返回的信息会在查询优化器优化查询时更新,因而不是会持久化的。
20
Specifies the name or ID of the indexes to be used by the query optimizer when it processes the statement. 指定查询优化器处理语句时要使用的索引的名称或ID。
21
Instead, the optimizer gathers up-to-date statistics on every database table referenced in a query. 相反,优化器将对查询中引用的每个数据库表收集最新的统计数据。
22
Think of the optimizer as an explorer waiting to navigate a mountain represented by the data in the system. 可以将优化器视为一个勘探器,正在系统中的数据所代表的大山中进行定位。
23
Unlike other heart-failure devices , the Optimizer works by strengthening the pumping force of the heart. 和其他治疗心衰装置不同的是,优化装置增强心脏泵血能力。
24
You can access the results and reports of various statistics within Google Website Optimizer to see which variant is the most effective. 你可以通过查看google网页优化工具的统计结果和报告,来判断哪一种页面变化能最有效率地提升转化率。
25
WideVine was a video optimizer and one of the last major independent digital rights managers. WideVine是一家视频优化公司,也是最后一批主要的独立数字版权管理者之一。
26
An estimate source of Guess indicates that the optimizer has no selectivity information to use . 如果查询被确定为是简单查询,则不会显示选择性统计信息,这样将绕过优化程序。
27
Almost every major database today uses some method of updating catalog statistics to provide the best information possible to its optimizer. 现在,几乎所有重要数据库都使用某种方法来更新目录统计信息,以便为其优化器提供可能的最佳信息。
28
The view does not have to be referenced in the query for the optimizer to consider that view for a substitution. 要使优化器考虑将该视图作为替换,并不需要在查询中引用该视图。
29
WebSphere Federation Server uses its cost-based optimizer to determine the most efficient means of resolving the multi-source query. WebSphereFederationServer使用它的基于成本的优化器决定执行多源查询的最有效的方式。
30
The query optimizer, in consultation with the wrapper, determines how the data is to be accessed. 查询优化器与包装器一道决定如何访问数据。