Skip to Content
0
Former Member
Jan 07, 2012 at 12:09 PM

Performace Tuning for BSIS table

55 Views

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