各位高手好:
一个简单的作业执行不完,但在查询分析器执行速度很快,这是什么问题呀?谢谢!
语句如下:
delete from tb_schcell
where cast(sc_schid as varchar)+','+ cast(sc_cellid as varchar) not in
(select cast(sch_id as varchar)+','+ cast(cell_id as varchar) from vw_RealTimeSchCell)insert into tb_schcell(sc_schid,sc_cellid,sc_flag)
select sch_id,cell_id,2100 from vw_RealTimeSchCell
where cast(sch_id as varchar)+','+ cast(cell_id as varchar) not in
(select cast(sc_schid as varchar)+','+ cast(sc_cellid as varchar) from tb_schcell )请各位指教,谢谢!
一个简单的作业执行不完,但在查询分析器执行速度很快,这是什么问题呀?谢谢!
语句如下:
delete from tb_schcell
where cast(sc_schid as varchar)+','+ cast(sc_cellid as varchar) not in
(select cast(sch_id as varchar)+','+ cast(cell_id as varchar) from vw_RealTimeSchCell)insert into tb_schcell(sc_schid,sc_cellid,sc_flag)
select sch_id,cell_id,2100 from vw_RealTimeSchCell
where cast(sch_id as varchar)+','+ cast(cell_id as varchar) not in
(select cast(sc_schid as varchar)+','+ cast(sc_cellid as varchar) from tb_schcell )请各位指教,谢谢!
我也同样遇到这样的问题,同样的存储过程,用作业调度就很慢,差不多要两个小时,但是在查询分析器中只要3分钟左右,求解~~~