Skip to Content
0

Select query Timeout error

Jan 25, 2017 at 11:27 AM

26

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers