select * from edw_acct_item a,prod_info o
where a.serv_id=o.prod_id
and o.account in ('111122','11133')
两个表情况说明:1.都是两个大表,数量百万级;
2.a表有索引serv_id,o表有建索引account
执行计划:见附件
--->上述查询,会全量查询 edw_acct_item,查询效率非常低,2分钟还查询不出来,请问如何解决哦?
而如果换成
select * from edw_acct_item a,prod_info o
where a.serv_id=o.prod_id
and o.account in ('111122')