【单选题】
A 使用mapjoin hint:select/*+mapjoin(t2)*/region_name,sum(order_amt)amt from order t1 join region t2 on t1.region_id=t2.region_id;
B 使用mapjoin hint:select/*+mapjoin(t1)*/region_name,sum(order_amt)amt from order t1 join region t2 on t1.region_id=t2.region_id;
C 调整两张表的位置:select region_name,sum(order_amt)amt from region t1 join t2 on t1.region_id=t2.region_id;
D 减小SQL的splitsize,增加计算资源
查看更多