请各位达人帮帮我:
下面的查询要用3分钟吗???select a.*, b.cust_name
from del_ord_hd a,customer b
where a.co_code = 'HH' and
a.do_prefix = '00' and
b.co_code = a.co_code and
b.cust_num = a.cust_num //都建有唯一索引
//a索引:a_idx (co_code,do_prefix,do_num)
//b索引:b_idx (co_code,cust_num)
//结果76952行
//表a:共154509行
//表b:共5043行
下面的查询要用3分钟吗???select a.*, b.cust_name
from del_ord_hd a,customer b
where a.co_code = 'HH' and
a.do_prefix = '00' and
b.co_code = a.co_code and
b.cust_num = a.cust_num //都建有唯一索引
//a索引:a_idx (co_code,do_prefix,do_num)
//b索引:b_idx (co_code,cust_num)
//结果76952行
//表a:共154509行
//表b:共5043行
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货