Skip to Content
avatar image
Former Member

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


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?


    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

  • Follow
  • Get RSS Feed

0 Answers