Skip to Content
0
Former Member
Sep 25, 2008 at 06:50 AM

how to porformance first in select qureey

52 Views

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 .