Hi All,
While selection of data from BSIS table , data is not comming in production server it is giving dump for time out.
So I have changed the code for peformance. I made a secondary idex ZCF and given field MANDT,BUKRS,HKONT,
GJAHR,BUDAT and MONAT.
And I wrote code like this.For HKONT I have the below criteria given by user.
SELECT bukrs hkont augdt augbl zuonr gjahr belnr
buzei budat xblnr blart monat shkzg dmbtr prctr
FROM bsis
INTO TABLE lt_bsis
WHERE bukrs IN s_bukrs
AND ( HKONT LIKE '0051%1' OR HKONT LIKE '0051%2' OR HKONT = '0022300010' )
AND gjahr = year
AND budat IN s_budat
AND monat = month
%_HINTS ORACLE 'INDEX("BSIS" "BSIS~ZCF")'.
Even then data have not fetchedd within 15 mints and give time out dum.
Can any body suggest me how can I write the code to reduce time.
Thanks,
Rakesh