Skip to Content
0
Former Member
Feb 23, 2009 at 04:27 PM

ST05 Trace Query

179 Views

Hi,

Can anyone tell me what this SQL does?

SELECT WHERE "MANDT" = '530' AND "LGNUM" = 'FG3' AND "LGTYP" = 'BLK' AND "LGPLA" = 'BB015' FOR UPDATE

This is the detail when click "Explain" button on ST05

SELECT

/*+

FIRST_ROWS

*/

*

FROM

"LAGP"

WHERE

"MANDT" = :A0 AND "LGNUM" = :A1 AND "LGTYP" = :A2 AND "LGPLA" = :A3

FOR UPDATE

What is the words "FOR UPDATE" means?

Can we specify index any index to speed up the query?