how to porformance first in select qureey

[Former Member]

Hello expart ,

how to porformance first in select statement

SELECT knumv kschl kbetr kumne INTO (itab_konv-knumv , itab_konv-kschl , itab_konv-kbetr , itab_konv-kumne )

FROM konv FOR ALL ENTRIES IN itab_orddate

WHERE knumv = itab_orddate-knumv .

append itab_konv .

endselect .

in prd server is its running slow . KONV table is cluster table .

how to porformance first in select statement using cluster tabale .

[Former Member]

make internal table itab which you want to store

if itab-orddate[] is not initial.

SELECT knumv kschl kbetr kumne INTO itab

FROM konv FOR ALL ENTRIES IN itab_orddate

WHERE knumv = itab_orddate-knumv .

append itab_konv .

endif.

use this code instead of that

Edited by: rajat malhotra on Sep 25, 2008 8:56 AM

[Former Member]

Hi,

Try code below :

data : begin of itab_konv occurs 0,
            knumv like konv-knumv,
            kschl  like konv-kschl,
            kbetr  like konv-kbetr,
            kumne  like konv-kumne,
        end of itab.


if not itab_orddate [ ] is initial.

SELECT knumv kschl kbetr kumne INTO table itab_konv.
FROM konv FOR ALL ENTRIES IN itab_orddate
WHERE knumv = itab_orddate-knumv .

Thanks,

Sriram Ponna.

[Former Member]

Hi,

AVOID SELECT ....ENSELECT..

Select data at a stretch.

if itab_orddate[] is not initial.

SELECT knumv kschl kbetr kumne INTO table itab_konv

FROM konv FOR ALL ENTRIES IN itab_orddate

WHERE knumv = itab_orddate-knumv .

Endif.

[Former Member]

if not itab_orddate[] is initial.

SELECT knumv kschl kbetr kumne INTO

table itab_konv

FROM konv FOR ALL ENTRIES IN itab_orddate

WHERE knumv = itab_orddate-knumv .

endif.