select * from a --数据少,速度快
select * from b --数据少,速度快select aa.* from
(select * from a ) aa,
(select * from b ) bb
where aa.id=bb.id这样查询却很慢,执行计划的hint应该怎么写,才能让他先执行里面的子查询呀
select * from b --数据少,速度快select aa.* from
(select * from a ) aa,
(select * from b ) bb
where aa.id=bb.id这样查询却很慢,执行计划的hint应该怎么写,才能让他先执行里面的子查询呀
(select * from a ) aa,
(select * from b ) bb
where aa.id=bb.id
lz为什么要用from aa, bb,而不是直接
select a.*
from a, b
where a.id = b.id
把执行计划贴出来嘛