Skip to Content
0
Nov 28, 2009 at 05:30 AM

Query Taking long time, is index possible.

18 Views

Dear Experts,

The following query is taking a long time to execute so going to dump.

is there any possibilities to speed up the query by creating index or some other methods?

if not i_final[] is initial.          
 select vbeln                          
        vbelv from vbfa                
       into table it_vbfa              
        for all entries in i_final     
       where vbeln = i_final-vbeln     
         and VBTYP_V = 'M'.            
 endif.

Thanks in advance

Lalit