Per-database locale settings 每数据库区域设置 Improved hash indexes 优化哈希索引 Improved join performance for EXISTS and NOT EXISTS queries 对于 EXISTS 和 NOT EXISTS 查询优化了查询性能 ..
基于12个网页-相关网页
如果连接列上不存在索引，那么优化器将选择动态哈希连接。
The optimizer will choose dynamic hash join if none of the joined columns has index.
在前一个实例中，如果customer . customer_num和orders . customer_num都没有被索引，那么优化器将选择动态哈希连接来作为最佳的执行计划。
In the previous example, if customer.customer_num and orders.customer_num are not indexed, dynamic hash join would be chosen by the optimizer as the best execution plan.
应用推荐