01-25-2017 11:27 AM
Hi Experts,
I have a Select query that is resulting in timeout error (only in Production). After analyzing, and trial and error, I think I can avoid the error by either introducing Package Size in Select query or by splitting the Select query (taking the View out) into 2. Both result in little extra time, 10-15%. Which one would be better? Any other solution to this problem or any other way to improve its performance?
SELECT a~wapos a~rectask d~fsavd a~mtetype e~wmrefnr2 d~ktext b~aufnr d~vornr d~ltxa1 d~tplnr d~objnr d~v_objnr
INTO TABLE i_fast_data
FROM zdc_rt_report AS a
INNER JOIN mhio AS b
ON a~wapos = b~wppos
INNER JOIN mpos AS e
ON a~wapos = e~wapos
INNER JOIN viaufk_afvc AS d
ON b~aufnr = d~aufnr and d~sumnr = ''
WHERE d~iphas < 3.
Regards,
Abhinav