两表的id都建有索引吗?
试试看:
select a.* from A a,B b where a.id=b.id;select * from A
minus
select a.* from A a,B b where a.id=b.id;
试试看:
select a.* from A a,B b where a.id=b.id;select * from A
minus
select a.* from A a,B b where a.id=b.id;
select id from a
minus
select id from b