Performance issue

[vinod_vemuru2]

Hi All,

I ahve doubt regarding Where clause in LOOP.

Which one will give better performance.

1. LOOP AT i_tab INTO wa_tab WHERE ......conditions

..Processing.

ENDLOOP.

2. LOOP AT i_tab INTO wa_tab.

IF conditions

..Processing.

ENDIF.

ENDLOOP.

Is it depends on total number of records/no of records that satisfy where clause in any way?

Regards,

Vinod.

[vinod_vemuru2]

Hi Vinod,

actually it depends on the indexing of the table, if indexing is well defined than first will be better else both are nearly same..

Regards

Anuj

[Former Member]

Hi,

LOOP AT i_tab INTO wa_tab WHERE ......conditions

..Processing.

ENDLOOP.

is the best way at any time.

it doesn't depend on the number of records.

rgds,

bharat.

[former_member404244]

Hi,

This will give better performance..

1. LOOP AT i_tab INTO wa_tab WHERE ......conditions

..Processing.

ENDLOOP.

Regards,

Nagaraj

[Former Member]

hi

the first option would be better,

at the begining of the loop only, all the not required rows are removed.

always prefer the 1st option for performance issue.

Regards,

Prasant

*reward if useful

[former_member196517]

Hi Vinod,

actually it depends on the indexing of the table, if indexing is well defined than first will be better else both are nearly same..

Regards

Anuj

[vinod_vemuru2]

Thanks u all