以下必须优化它太慢了。
Select count ( a.style_no ) From style_stru_samplelist a , mat_material b Where a.matno =b.matno and b.jgflag ='1' and a.splno ='090207094' and a.style_no ='AA70087-29' and convert ( varchar ( 10 ) , flowno ) + a.matno not in ( select convert ( varchar ( 10 ) , flowno ) + matno from style_stru_samplelist_jg )
READS=212477,CPU=2188,DURATION=80970
订单复制样品BOM时其中一个语句。
[@more@]
Select count ( a.style_no ) From style_stru_samplelist a , mat_material b Where a.matno =b.matno and b.jgflag ='1' and a.splno ='090207094' and a.style_no ='AA70087-29' and convert ( varchar ( 10 ) , flowno ) + a.matno not in ( select convert ( varchar ( 10 ) , flowno ) + matno from style_stru_samplelist_jg )
READS=212477,CPU=2188,DURATION=80970
订单复制样品BOM时其中一个语句。
[@more@]
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/729024/viewspace-1023829/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/729024/viewspace-1023829/
787
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
