Skip to Content
0
Former Member
Oct 15, 2009 at 09:58 AM

Increase the performance of a select with Join !

60 Views

Hi fox,

the bollow select takes loooooooots of time to deliver a result. I know already that "join" is time consuming but is there any way to make this faster or the only way would be to gather the data in many single steps together. The other question is do you think it's a good idea to put the mara and marc in front ?

Cheers

Kami

Ps: the "lc_qry" is a long string which would be built dyn.

SELECT mvkevkorg mvkevmsta marcmatnr marcwerks marccuobj marcstdpd mara~mtart

INTO CORRESPONDING FIELDS OF TABLE i_mtnr_ppl_sorg

FROM ( mvke

INNER JOIN marc

ON mvkematnr = marcmatnr

INNER JOIN mara

ON maramatnr = marcmatnr )

WHERE (lc_qry).