返回数说广场
0
有以下查询:
select t1.name from t1,t2 where t2.id = t1.id。
如果想让优化器首先访问T2,之后在关联T1。
可以通过下面哪种写法?
A select /*+ STRAIGHT_JOIN */t1.name from t2 join t1 on t2.id = t1.id;
B select /*+ STRAIGHT_JOIN(t2,t1) */t1.name from t2 join t1 on t2.id = t1.id;
C select /*+ STRAIGHT_JOIN(t2,t1) */t1.name from t2 , t1 where t2.id = t1.id;
D select t1.name from t2 STRAIGHT_JOIN t1 on t1.id = t2.id;
D
0
0 355
分享
评论
热门数说


