Join Kna1 with cdhdr is slow

[former_member1035858]

Hi,

I am using this query and the first time it is executed takes 300 seconds, but in the next execution it takes 5 seconds.

SELECT kna1~kunnr cdhdr~objectid cdhdr~changenr cdhdr~udate cdhdr~change_ind
    FROM kna1 AS kna1
   INNER JOIN cdhdr AS cdhdr
      ON cdhdr~objectid EQ kna1~kunnr 
   WHERE cdhdr~objectclas EQ 'DEBI'.

Does anyone know why?

Best Regards,

[Jelena]

Because of data buffering.