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?