Skip to Content
0
Former Member
Jun 20, 2008 at 06:46 AM

Performance Tuning "Select All" vs "Select Then Delete"

61 Views

Dear Experts,

Please tell me which one has better prefromance between

SELECT a~vbeln

a~kunnr

a~bukrs_vf

a~vkorg

a~vtweg

a~spart

a~augru

a~vbtyp

a~auart

a~bstnk

b~kunnr

INTO TABLE ivbak

FROM vbak AS a

INNER JOIN vbpa AS b

ON bvbeln EQ avbeln

AND b~parvw EQ c_shipto

WHERE a~kunnr IN s_kunnr AND

a~vkorg EQ p_vkorg AND

a~vtweg IN s_vtweg AND

a~spart IN s_spart and

a~auart in s_auart .

DELETE ivbak WHERE NOT (

vbeln IN s_vbeln AND

augru EQ space AND

vbtyp EQ s_order AND

kunno IN s_kunev ).

DELETE ivbak WHERE auart EQ ordertype2

OR auart EQ ordertype1.

DELETE ADJACENT DUPLICATES FROM ivbak COMPARING ALL FIELDS.

AND

SELECT a~vbeln

a~kunnr

a~bukrs_vf

a~vkorg

a~vtweg

a~spart

a~augru

a~vbtyp

a~auart

a~bstnk

b~kunnr

INTO TABLE i_vbak

FROM vbak AS a

INNER JOIN vbpa AS b

ON bvbeln EQ avbeln

AND b~parvw EQ c_shipto

WHERE a~kunnr IN s_kunnr AND

a~vkorg EQ p_vkorg AND

a~vtweg IN s_vtweg AND

a~spart IN s_spart AND

a~auart in s_auart AND

a~vbeln NOT IN s_vbeln AND

a~augru NE SPACE AND

a~vbtyp NE s_order OR

(auart EQ ordertype2

OR auart EQ ordertype1)