The result set from FETCH (3) is ordered by the ID column and joined using a merge join with index I1 for T1 to get final result set.
FETCH(3)的结果集是根据ID字段排序的,并且使用T1的索引I1的合并联接而得到最终的结果集。
If the XML index is defined as double, you cast the join predicate with xs: double.
如果将xml索引定义为double,则用xs: double转换连接谓词。
If the XML index is defined as VARCHAR, you cast the join predicate with fn: string, and so forth as you see in Table 6.
如果将xml索引定义为VARCHAR,则用fn:string转换连接谓词,如表6所示。
In general, a nested loop join with sort composite is favored by the optimizer if the inner index is well-clustered and the inner table is expected to be probed many times.
一般来说,如果内部索引是良好的集群且预测内部表被多次探测,则使用复合排序的嵌套循环联将受到优化器的青睐。
For the reason of the no order of space data, the algorithm based on join index have to improve for it. The key problem of optimal page-access sequence with a fixed Buffer has been analyzed.
空间数据的无序性,使得应用在其上的利用连接索引的算法需要进一步的改进,为此分析了其中关键的最佳页访问次序问题。
For the reason of the no order of space data, the algorithm based on join index have to improve for it. The key problem of optimal page-access sequence with a fixed Buffer has been analyzed.
空间数据的无序性,使得应用在其上的利用连接索引的算法需要进一步的改进,为此分析了其中关键的最佳页访问次序问题。
应用推荐