Skip to Content
0

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

Aug 03, 2017 at 07:26 AM

26

avatar image
Former Member

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>
SQL
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers