Skip to Content
0
Former Member
Feb 16, 2009 at 11:34 AM

Performance : Inner join on four tables

118 Views

Hi All,

Here is a query using inner join on four tables for which i have to improve performance,

SELECT vbak~vbeln

vbak~auart

vbak~waerk

vbak~vdatu

vbak~vsbed

vbak~bstnk

vbak~kunnr

vbap~posnr

vbap~matnr

vbap~abgru

vbap~prodh

vbap~netwr

vbap~kwmeng

vbap~vrkme

vbap~brgew

vbap~gewei

vbap~werks

vbap~kzwi1

vbap~kzwi2

vbuk~lfgsk

vbpa~kunnr

vbpa~parvw

INTO

(t_collector-vbeln,

t_collector-auart,

t_collector-waerk,

t_collector-vdatu,

t_collector-vsbed,

t_collector-bstnk,

t_collector-kunnr,

t_collector-posnr,

t_collector-matnr,

t_collector-abgru,

t_collector-prodh,

t_collector-netwr,

t_collector-kwmeng,

t_collector-vrkme,

t_collector-brgew,

t_collector-gewei,

t_collector-werks,

t_collector-kzwi1,

t_collector-kzwi2,

t_collector-lfgsk,

t_collector-kunnr_p,

t_collector-parvw)

FROM vbak AS vbak

INNER JOIN vbuk AS vbuk

ON vbakvbeln = vbukvbeln

INNER JOIN vbap AS vbap

ON vbakvbeln = vbapvbeln

INNER JOIN vbpa AS vbpa

ON vbakvbeln = vbpavbeln

WHERE vbak~vbeln IN so_vbeln AND

vbak~erdat IN so_erdat AND

vbak~vbtyp IN so_vbtyp AND

vbak~vkorg IN so_vkorg AND

vbak~vtweg = pa_vtweg AND

vbak~spart = pa_spart AND

vbak~vdatu IN so_vdatu AND

vbak~vsbed IN so_vsbed AND

vbuk~lfgsk IN so_lfgsk AND

vbpa~kunnr IN so_kunnr AND

vbpa~parvw IN so_parvw.

APPEND t_collector.

ENDSELECT.

Please suggest whether i have to use threee different queries with joins or shall go ahead and use first a join and then seect for all entries follwed by looping....

Please tell me briefly how can i proceed to split this query.

Thanks in advance,

Rama.