导读:into corresponding fields. into corresponding fields.Hi,When i search on ‘Performance‘ in this forum,i noticed many posts suggest Not to use into Corresponding fields of ..and i have a progr...
into corresponding fields.
into corresponding fields.
Hi,When i search on 'Performance' in this forum,i noticed many posts suggest Not to use into Corresponding fields of ..and i have a program with this selection,therefore would apprecieate any good suggestion..select z"kunnr z"VKORG z"erdat z"auart z"vdatu a"vbeln a"posnr a"kwmeng a"klmeng a"netwr a"PSTYV a"werks a"VRKME b"absta b"lfsta a"matnr a"prodh c"bukrs into corresponding fields of table TA_VBAP from VBAK as Z join VBAP as a on Z"vbeln = a"vbeln join vbup as b on a"vbeln = b"vbeln and a"posnr = b"posnr join TVKO as c on Z"vkorg = c"vkorg where z"kunnr in l_kunnr and z"vdatu in l_vdatu and z"auart in l_auart and Z"vkorg in l_vkorg and z"vbeln in l_vbeln.how can this be improved thanks...
la9013
1年前他留下的回答
已收到1个回答
fjm_moto
网友
该名网友总共回答了21个问题,此问答他的回答如下:采纳率:85.7%
Most importantly though, change your WHERE condition so that the keys (VBELN) appear first. Depending on your database this could really mess up thinks if you don't place the keys first. This is good practice regardless of the database being used.Other than that, do as gaurav_anand7 suggested.Oh yeh, and swap the orde rof your ON clause so that:Code: Select allon Z"vbeln = a"vbeln becomes Code: Select allON a"vbeln = z"vbelnThis, depending again on your database, can make a difference.Dr Sidewalk 查看原帖
1年前他留下的回答
3
以上就是小编为大家介绍的into corresponding fields. 的全部内容,如果大家还对相关的内容感兴趣,请持续关注上海建站网!
标签:
内容声明:网站所展示的内容均由第三方用户投稿提供,内容的真实性、准确性和合法性均由发布用户负责。上海建站网对此不承担任何相关连带责任。上海建站网遵循相关法律法规严格审核相关关内容,如您发现页面有任何违法或侵权信息,欢迎向网站举报并提供有效线索,我们将认真核查、及时处理。感谢您的参与和支持!