select *
from table1
where (rec_id in
(select stId
from department
start with stId = '222222'
CONNECT BY PRIOR stId = faId) or
sendId in
(select stId
from department
start with stId = '222222'
CONNECT BY PRIOR stId = faId))
order by send_time
在表的send_time(date字段)、rec_id(char字段)和sendId(char字段)创建了索引
当order by rec_id时,查询时间1s内,当order by send_time时,查询时间20s,求解
from table1
where (rec_id in
(select stId
from department
start with stId = '222222'
CONNECT BY PRIOR stId = faId) or
sendId in
(select stId
from department
start with stId = '222222'
CONNECT BY PRIOR stId = faId))
order by send_time
在表的send_time(date字段)、rec_id(char字段)和sendId(char字段)创建了索引
当order by rec_id时,查询时间1s内,当order by send_time时,查询时间20s,求解
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货