hi Query Slow (Urgent)

[Former Member]

hi all

i've written following coding for despatch register.

while running it takes long time, can any one change bellow coding

SELECT SUM( lips_{LFIMG ) vbak}vbeln vbak_{kunnr vbak}vkorg

vbak_{knumv lips}vbeln INTO

(del-lfimg, reg-vbeln, reg-kunnr, reg-vkorg,

reg-knumv, del-vbeln) FROM lips

INNER JOIN vbak ON lips_{VGBEL eq vbak}vbeln

inner join vbuk on lips_{VBELN eq vbuk}vbeln

inner join LIKP on likp_{VBELN eq lips}VBELN

WHERE vbak_{VKORG in s_vkorg and vbak}kunnr in skunnr and

likp~WADAT_IST in delvdate and

vbuk~WBSTK eq 'C' and

( vbak_{auart NE 'RE' AND vbak}auart NE 'QT' ) AND

( lips_{PSTYV EQ 'TAN' OR lips}PSTYV EQ 'TAC' OR

lips_{PSTYV EQ 'TASS' ) GROUP BY vbak}kunnr

vbak_{vbeln vbak}vkorg vbak_{knumv lips}vbeln

ORDER BY vbak~kunnr.

......

......

.....

endselect.

[Former Member]

tooo many tables in JOIN .

first break them into small Query.

2.what abt ur WHERE clause ?.

Regards

Prabhu

[Former Member]

TRY TO USE ONLY TWO TABLES IN INNER JOIN.

IF YOU HAVE TO FETCH AS PER YOUR REQUIREMENT IN ONE SELECT CREATE A VIEW OF THOSE TABLES AND USE THE VIEW

REGARDS

SHIBA DUTTA

[Former Member]

hi

dont use select-endselect statement.

instead of using into 'header line', use INTO CORRESPONDING FIELDS OF TABLE internal table, which would increase your performance.

thx

pavan

[jayanthi_jayaraman]

Hi,

Try to avoid more inner joins.Use for all entries instead of that.

Avoid using select endselect.Instead of the use into table in select statement.