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?