Skip to Content
0
Jul 14, 2008 at 09:29 AM

Optimizing select question ..

28 Views

I have a select statement which takes an awful time to execute

the problem is that the only factor I know is the BUDAT

now I was looking if I could use an index. there is an index on the BKPF which contains the BUDAT, BSTAT and BUKRS

to make this index happen I have to add alt the available BSTATs into a range and all available BUKRS to a range and add it to the select

now I wonder if this would really enhance the performance of the select statement ??


  SELECT bukrs belnr gjahr FROM bkpf
           INTO CORRESPONDING FIELDS OF TABLE ta_bkpf
           WHERE budat GE p_budat.

kind regards

arthur de smidt