Skip to Content
0
Former Member
Nov 24, 2006 at 01:59 PM

Optimizing code

28 Views

Hi, I want to optimize the next select.... it tooks almost 4 minutes to execute

vbpa have 5.200.182 records

vbap have 1.344.536 records

SELECT DISTINCT akunnr bwerks

INTO TABLE t_cus_werk

FROM ( vbpa AS a INNER JOIN vbap AS b ON avbeln = bvbeln )

WHERE b~werks = p_werks AND

b~erdat IN r_date.

If we could reduce the time to half 😊

Best regards

Juan