以下必须优化它太慢了。
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博客 ” ，链接：https://blog.itpub.net/729024/viewspace-1023829/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
AWE和PAE功能设置
请登录后发表评论
登录
全部评论
