topic performance improvement for select query in Application Development and Automation Discussions

performance improvement for select query

Former Member — Tue, 12 Oct 2010 06:00:53 GMT

Hi all,

need to improve performace for the below select query as it is taking long time

SELECT vbeln pdstk

FROM vbuk INTO TABLE it_vbuk1 FOR ALL ENTRIES IN it_likp

WHERE vbeln = it_likp-vbeln AND

wbstk = 'C' AND "pdstk = ' ' AND

vbtyp IN gr_delivery AND

( fkstk = 'A' OR fkstk = 'B' ) OR

( fkivk = 'A' OR fkivk = 'B' ).

Regards,

Kumar

Re: performance improvement for select query

Former Member — Tue, 12 Oct 2010 06:10:57 GMT

An extra parenthesis will solve the problem

SELECT vbeln pdstk
FROM vbuk INTO TABLE it_vbuk1 FOR ALL ENTRIES IN it_likp
WHERE vbeln = it_likp-vbeln 
AND wbstk = 'C' 
AND pdstk = ' ' 
AND vbtyp IN gr_delivery 
AND(( fkstk = 'A' OR fkstk = 'B' )   
 OR
( fkivk = 'A' OR fkivk = 'B' )).

Also ensure IT_LIKP is not initial before using in FOR ALL ENTRIES IN

Re: performance improvement for select query

Former Member — Tue, 12 Oct 2010 06:11:32 GMT

Hi,

Check if it_likp is sorted on vbeln.

SELECT vbeln pdstk

FROM vbuk INTO TABLE it_vbuk1 FOR ALL ENTRIES IN it_likp

WHERE vbeln = it_likp-vbeln AND

wbstk = 'C' AND

vbtyp IN gr_delivery AND

( ( fkstk = 'A' OR fkstk = 'B' ) OR <-- check this condition , if ( ) is needed ...

( fkivk = 'A' OR fkivk = 'B' ) ) .

Regards,

Srini.

Re: performance improvement for select query

Former Member — Tue, 12 Oct 2010 13:53:34 GMT

Moderator message - Please see before posting - post locked Rob