Skip to Content
0
Former Member
Apr 06, 2006 at 10:20 AM

Performance related to BSAK

118 Views

Hi Guys,

I have been using the BSAK table in the report. The table has 5.5 crore records. I'm using the simple select statement to get the records from it. But it's taking 45 minutes to get the records of 3 months (Around 15 lakhs). I tried with all the options (like secondary index) but there is no use.

Do you guys have any idea how to improve the performance of this select statement? Any sugestions would be really helpful. Thanks in advance.

SELECT BUKRS

GJAHR

BELNR

BUDAT

BLART

GSBER

DMBTT

INTO TABLE I_BSAK

FROM BSAK

WHERE BUKRS IN S_BUKRS

AND GJAHR IN S_GJAHR

AND BUDAT IN S_BUDAT

AND BLART IN S_BLART

AND GSBER IN S_GSBER.