Skip to Content
0
Former Member
Mar 24, 2009 at 07:32 AM

Performance of Delete Statement

261 Views

Hello Everybody,

could you please tell me, which is better Delete statement and why from below statements.

1. DELETE FROM (lv_lead_table) WHERE pcrnr IN lt_pcrnr_temp.

2. DELETE (lv_lead_table) FROM TABLE <lead_backup_table> and

3. DELETE FROM (lv_lead_table) WHERE date_field LT target_field.

I also interested to know that how system will generate internal select statement for above statement.

Thanks in advance.

Regards,

Anil