This plan USES two XISCANs, one for each predicate and index.
该计划使用两个XISCAN,分别用于每一个谓词和索引。
If only one XML index is available, then DB2 cannot apply this guideline and will instead produce the cheapest alternative plan.
如果只有一个xml索引是可用的,那么DB 2将无法应用这个准则,因而将生成成本最低的替代计划。
Tuning can include adding extra indexes to yield a more efficient access plan, which makes tables volatile to encourage index usage and avoid table scans if possible.
调优包括添加额外索引来生成一个更高效的访问计划,让表格变幻无常,进而鼓励索引的使用,如果可能的话也可以避免表扫描。
The index attribute is optional and allows you to specify an index name that will be used as the leading index in an 'IXAND' plan.
index属性是可选的,并允许您指定一个索引名来作为“IXAND”计划中的主索引。
With the new index created, and statistics collected on it, the optimizer corrects the cardinality estimate of the query access plan.
然后优化器会使用新创建的索引和在其上收集的统计信息来更正查询访问计划的基数估计值。
Here we are using the two indexes, and we have the same predicate, this time on the index scan numbered 3 in the plan.
在这里我们使用了两个索引,并且有同样的谓词,这一次针对计划中编号为3的索引扫描。
An XISCAN plan if only a single index is defined on the table and it is of type XML.
一个XISCAN计划,前提是只对表定义了一个单一的索引并且其类型为XML。
The execution plan on the left shows the index AND 'ing plan that DB2 would have to consider to catch your sample document.
左侧的执行计划展示了索引AND' ing的执行计划,DB 2必须考虑捕获示例文档。
In the example in Listing 20, the IXAND guideline specifies that the table SECURITY should be accessed using an IXAND plan and that the XML index SEC_INDUSTRY must be the first index under the IXAND.
在清单20的示例中,IXAND准则指定应当使用IXAND计划访问表security,并且xml索引sec _ INDUSTRY必须是IXAND下的第一个索引。
The index elements can optionally specify two or more indexes that will be used in the 'IXAND' plan in the specified order and no additional indexes will be added by the optimizer to the IXAND.
INDEX元素可以选择性地指定两个或更多索引,它们将按照指定的顺序应用到“IXAND”计划中,并且优化器不会向IXAND添加更多的索引。
Evaluation index system of passenger train operation plan is the basis for evaluating and optimizing passenger train plan.
旅客列车开行方案评价指标体系是评价和优化开行方案的基础。
To illustrate this, compare it to the predicate that is applied to the index scan numbered 5 in the plan, which is on the one and only column of the index on the child table.
为了展示这一点,将它与计划中第5号索引扫描上使用的谓词相比较,它针对子表中惟一的索引列。
After deciding purchase policy, tactic, target and action plan, the enterprise should have the relative performance index for controlling the purchase process during implementing the plan.
作为企业,在制定采购方标、战略、目标及实现相应目标的行动计划后,在计划实施时还需有相应的绩效指标,用于对采购过程进行检查控制。
This paper USES time and cost as the assessment index to make quantity appraise of the process plan.
本文以工艺方案的时间与成本作为评价指标,对工艺方案进行了定量评价。
This paper introduces the principle, technical index of tools, and applicable scope of downhole throttling process, and provides a concrete plan implemented in Shuangtuozi gas field.
介绍了井下节流工艺原理、工具技术指标及适用范围,给出了具体实施方案设计在双坨子气田开发中的应用。
I have implemented an index maintenance plan that checks and rebuilds these indexes when necessary every few hours.
我已经实现了一个索引维护计划,检查和重建这些指标,必要时每隔几小时。
According to BMI, everyday life, diet habit and activities of diabetes patients, make thermal diet plan, all kinds of healthy education and follow the study several physiological index.
根据患者BMI、日常生活、饮食习惯、活动量制定相应热卡的饮食计划,可进行各种形式的健康教育,并追踪调查各项生理指标。
The evaluation index of the operation efficiency of the traffic system in the area traffic plan is the important basis for selecting traffic system organization and planned option.
地区交通规划中交通系统运行效率评价指标,是交通系统组织与规划方案选择的重要依据。
This paper discussed the optimized skills of enquiry from the perspectives of index , hints and enquiring executive plan .
本文从索引、提示和查询执行计划等角度来讨论查询优化技巧,希望能给大家带来一些帮助。
Then, it focused on the evaluation index system and evaluation methods, of which emergent traffic organization plan in the context of the road network.
着重研究了路网环境下高速公路紧急交通组织预案评价指标体系和评价方法。
The index enrich the information of the study on the distribution supply electric capability, instructive and operable in design-programming and making of operation plan.
配电网最大负荷供应能力指标,丰富了配电网供电能力研究的内容,可以有效指导配电网的设计规划、制定运行计划。
Technical verification of the plans is considered in the assessment process. Whether a plan is effective is defined by its input and output index values entirely.
该方法将黑启动方案的技术校验结果纳入评估体系,并依据实际的输入、输出指标值做出方案是否有效的客观评价。
This paper establishes the test system's general design plan according to the consumer's request and technique index in relative railway standard.
本文根据用户提出的技术指标完成了试验系统软硬件设计。
Open-pit Mines should be planed and with the economic benefits index changing the plan should be changed .
露天矿的开采必须是有计划的,而且随着影响经济效益变量的变化而变化。
Open-pit Mines should be planed and with the economic benefits index changing the plan should be changed .
露天矿的开采必须是有计划的,而且随着影响经济效益变量的变化而变化。
应用推荐