sql查询语句优化--在线等

显示全部楼层 · 2008-9-20 11:09:35

select * from d_Move
where moveid in (select moveid from #sh )
or moveid in (select moveid from #klk)
请问以上语句可以怎样优化查询速度....速度!
注：必须是2个临时表的情况下优化

千问 · 2008-9-20 11:09:35

UNION 运算符将两个SELECT 语句的结果组合成一个结果集。这样有利于d_Move表基于moveid字段索引查询优化select * from d_Move where moveid in (select moveid from #sh union select moveid from #klk)...

千问 · 2008-9-20 11:09:35

建议：#sh #klk组合成新的视图。 V_shklkselect 字段1，字段2 from D_move where Moveid any=(select * from V_shklk)...

千问 · 2008-9-20 11:09:35

SELECT * FROM d_MoveWHEREmoveid IN
(select moveid from #sh
UNION
select moveid from #klk
)...

千问 · 2008-9-20 11:09:35

已经很好了，复杂了不好...