Bitmap Join Index 位图连接索引 ; 位图衔接索引 ; 位图联结索引
join index 连接索引
Bitmap-join Index 位图连接索引
spatial join index 空间连接索引
bit join index 位图连接索引
Bitmapped Join Index 位图连接索引
index join 索引连接
Join with index 索引连接
join result index 连接结果索引
The optimizer will choose dynamic hash join if none of the joined columns has index.
如果连接列上不存在索引,那么优化器将选择动态哈希连接。
This is a lot faster than a nested loop join of two table scans without any index usage.
这比不使用任何索引的两个表扫描的嵌套循环连接要快得多。
The guideline specifies that table SECURITY should be the outer table in the join and the XML index SEC_INDUSTRY should be used to access the SECURITY table.
该准则指定应当将表 SECURITY 作为连接中的外表,而 XML 索引 SEC_INDUSTRY 应当被用于访问 SECURITY 表。
应用推荐