topic performance issue in select query in Application Development and Automation Discussions

performance issue in select query

Former Member — Wed, 17 Dec 2008 10:29:31 GMT

Moderator message: do not post the same question in two forums. Duplicate (together with answers) deleted.

SELECT a~grant_nbr
        a~zzdonorfy
        a~company_code
        b~language
      b~short_desc
INTO TABLE i_gmgr_text
FROM gmgr AS a
INNER JOIN gmgrtexts AS b ON a~grant_nbr = b~grant_nbr
WHERE a~grant_nbr  IN s_grant
AND   a~zzdonorfy  IN s_dono
AND   b~language   EQ sy-langu
AND   b~short_desc IN s_cont.

How to use for all all entries in the above inner join for better performance?

then....

  IF sy-subrc EQ 0.
    SORT i_gmgr_text BY grant_nbr.
  ENDIF.

  IF i_gmgr_text[] IS NOT INITIAL.

* Actual Line Item Table
    SELECT rgrant_nbr
           gl_sirid
           rbukrs
           rsponsored_class
           refdocnr
           refdocln
    FROM gmia
    INTO TABLE i_gmia
    FOR ALL ENTRIES IN i_gmgr_text
    WHERE rgrant_nbr        = i_gmgr_text-grant_nbr
    AND   rbukrs            = i_gmgr_text-company_code
    AND   rsponsored_class IN s_spon.

    IF sy-subrc EQ 0.
      SORT i_gmia BY refdocnr refdocln.
    ENDIF.

Edited by: Matt on Dec 17, 2008 1:40 PM

Re: performance issue in select query

matt — Wed, 17 Dec 2008 12:42:51 GMT

Do not post the same question in two forums. Do surround your abap with tags.

Now. Why on earth do you think that "for all entries" is better performing that "inner joins".

( and anyone who just posts an answer, rewriting the posters code with "for all entries", will have their reply rejected, unless they justify why their code is better ).

Re: performance issue in select query

Former Member — Thu, 18 Dec 2008 09:33:09 GMT

> How to use for all all entries in the above inner join for better performance?

my best christmas recommendation for performance, simply ignore such recommendations.

And check the performance of your join!

Is the performance really low, if it is then there is probably no index support. Without indexes FOR ALL ENTRIES will be much slower.

Siegfried

Re: performance issue in select query

Former Member — Fri, 19 Dec 2008 07:39:39 GMT

This message was moderated.

Re: performance issue in select query

Former Member — Fri, 19 Dec 2008 09:04:31 GMT

As performance point of view innner join is not good. To improve performance you have to made two internal table.And make for all entries in the second internal table.like this

Re: performance issue in select query

Former Member — Fri, 19 Dec 2008 11:18:30 GMT

> As performance point of view innner join is not good. To improve performance you have to made two

> internal table.And make for all entries in the second internal table.like this

please stop writing nonsense recommendations! Did you ever test what you write ... I guess no.