Skip to Content
avatar image
Former Member

Why select from vrkpa is very slow when the first time to excute every day?

Hi;

Below is my select statement.

everyday, when the sql is executed by the first time, it is very slow. But when it is executed again, it is very fast, about 1/20 time consuming of the first time.

What should I do to improve the fist executing performance?

SELECT * INTO TABLE lt_vrkpa

    FROM vrkpa

    WHERE kunde IN rs_kunde AND  "empty

          parvw EQ 'RG' AND

          vkorg IN s_vkorg AND "one record

          fkdat IN s_fkdat AND "1 year

          vtweg IN s_vtweg AND " one record

          fkart IN s_fkart AND " one record

          kunag IN s_kunag. " one record<br>
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers