Select query Timeout error

Former Member — Wed, 25 Jan 2017 11:27:45 GMT

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

topic Select query Timeout error in Application Development and Automation Discussions

Select query Timeout error