The two rightmost columns in table 1 represent two alternative index definitions, and the rows in the table show which of the predicates can (+) or cannot (-) be evaluated by either of the indexes.
表1最右侧的两列表示两个可选择的索引定义,表中各行展示了谓词可以(+)或不可以(-)由这两个索引进行计算。
If only one XML index is available, then DB2 cannot apply this guideline and will instead produce the cheapest alternative plan.
如果只有一个xml索引是可用的,那么DB 2将无法应用这个准则,因而将生成成本最低的替代计划。
This is partly because there are alternative numbers to go on; CLSA, for example, produces its own purchasing-managers’ index.
这部分归功于许多替代数据;比如说,里昂证券编制自己的采购经理指数(见注一)。
应用推荐