Skip to Content
0
Former Member
Feb 17, 2009 at 10:42 AM

Time out error

28 Views

Hi,

The below select statement is giving TIME_OUT error in production system.

SELECT filkd bukrs belnr buzei blart bldat bschl budat

dmbtr hkont kunnr rebzg mansp madat manst

shkzg umskz vbund xblnr

zbd1t zbd2t zbd3t zfbdt zterm

FROM bsid

INTO TABLE t_bsid

WHERE bukrs IN s_bukrs

AND kunnr IN s_kunnr

AND umskz IN s_umskz

AND augdt EQ w_augdt_null

AND augbl EQ w_augbl_null

AND budat <= p_keydat.

The select statement is using primary index but still it is causing time out error.Can anyone tell me how to improve the performance of this select statement?