...求有索引,也不管是什么连接条件,最简单 – 通过外层循环和内层循环完成属性拼接 – 代价很大 • 索引连接 ( Join with index ) – 用索引查找替代文件扫描 – 可用于已有索引或专门建立临时索引的情形 • 归并连接(Merge join) – 可用于计算自然连接和...
基于12个网页-相关网页
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所示。
应用推荐