Performance Tunning- data extraction from FMGLFLEXA table

[Former Member]

Hi,

Need to fetch data from FMGLFLEXA table based on below condtion.

WHERE rfund IN s_rfund

AND rgrant_nbr IN s_rgnbr

AND rbusa IN s_rbusa

AND budat LE v_hbudat.

Please tell me how can i optimize this extaraction b'coz in production system there are lacks of records.

Regards,

Shweta.

[Former Member]

create a index on these fields due to which data extraction from table will be fast.