Skip to Content
0
Oct 23, 2019 at 08:53 AM

Join Kna1 with cdhdr is slow

111 Views

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,