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