Skip to Content
0
Former Member
Jan 21, 2008 at 08:33 AM

Performence issue on Select statement

15 Views

Hi all,

BKPF is very huge table in production server and its mandatory to retrive records. there is no suible secondary idexes also.

how to overcome this problem

SELECT bukrs belnr gjahr blart bldat budat monat

usnam xblnr waers awsys xref1_hd xref2_hd

FROM bkpf

INTO TABLE i_bkpf

WHERE bukrs IN s_bukrs AND

gjahr IN s_gjahr AND

blart IN s_blart AND

bldat IN s_bldat AND

budat IN s_budat AND

monat IN s_monat AND

usnam IN s_usnam AND

awsys EQ c_zgiqadkob.

all suggestions are welcome

Regards, Sri harsha