BSIS Query performance issue.

[dani_mn]

HI,

our BSIS table contains almost 10 millions records, now during check printing process when we are quering BSIS table for getting cost center from the line item.

it is taking almost 30-60 seconds which is slowing the check printing process.

 SELECT single * FROM BSAK
  WHERE BUKRS = COMP AND GJAHR = YR AND AUGBL = PDOC AND BELNR <> PDOC.

  SELECT SINGLE * FROM BSIS WHERE
  BELNR =  BSAK-BELNR  AND BUKRS = COMP AND GJAHR = YR
  AND ( HKONT LIKE 'A%' OR BLART = 'RE' ).

 kostl = bsis-kostl.

for getting cost center first it picks the FI document number from BSAK using Payment document number. and then getting cost center from bsis.

Is there any alternative way of getting cost center of document skiping BSIS.

Thanks,

[Former Member]

hi,

if you are firing this query regularly then create intex on bsis table.

performance can improve by creating index only.

regards,

raj

[graghavendra_sharma]

Hi

I have a question here. If you are using SELECT SINGLE * ... then where from ENDSELECT came into picture?