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. 的全部内容，如果大家还对相关的内容感兴趣，请持续关注上海建站网！