1. always_anti_join来设置anti_join的方式,选择有:
星型连接、网状连接、哈希连接; Sort_Direct_writes :
The SORT_DIRECT_WRITES initialization parameter is obsolete in release 8.1 and higher. If you had SORT_DIRECT_WRITES set to FALSE or AUTO in a past release,
then the sort buffers were kept in the buffer cache whenever possible. Because SORT_DIRECT_WRITES is obsolete in release 8.1, the sort buffers could go directly to
disk if you do not adjust your SORT_AREA_SIZE initialization parameter. 先给你找到了这些!!
星型连接、网状连接、哈希连接; Sort_Direct_writes :
The SORT_DIRECT_WRITES initialization parameter is obsolete in release 8.1 and higher. If you had SORT_DIRECT_WRITES set to FALSE or AUTO in a past release,
then the sort buffers were kept in the buffer cache whenever possible. Because SORT_DIRECT_WRITES is obsolete in release 8.1, the sort buffers could go directly to
disk if you do not adjust your SORT_AREA_SIZE initialization parameter. 先给你找到了这些!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货