暂无图片
返回数说广场
鱼的记忆
2023-05-05
有以下查询: 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
分享

评论

热门数说