Skip to Content
0
Former Member
Nov 06, 2006 at 04:43 PM

COMMIT Work

71 Views

Hello All,

I have a simple code:

<i><CODE>

data: begin of itab occurs0,

f1 like table-f1,

f2 like table-f2,

f3 like table-f3,

f4 like table-f4,

end of itab.

SELECT F1 F2 F3 F4 FROM TABLE INTO itab

where clause.

COMMIT WORK. <------

</CODE></i>

Is this code acceptable from a Performance Improvement point of view?

I did read the documentation of COMMIT which informs that COMMIT after the SELECT statement commits an implicit commit on the DB and the WorkProcessor attached with that particular SELECT statement gets freed. In a way this help in the Improvement.

Could any one confirm on this with any of the documents from SAP.

Thank you,

-PSK