Saturday, 9 March 2013

The two queries below, which is more efficient? | SAP HANA Multiple Choice Questions

a.        Matmoves = SELECT * FROM MSEG
FOR EACH matmove in matmoves
       IF matmove.whichPlant = “I” THEN
                Plant_text = SELECT plant_text FROM WERKS WHERE id = matmove.plant
          ELSE
                Plant_text = SELECT plant_text FROM WERKS_EXT WHERE id=matmove.
plant
         END


b.         If which_plant = “I” THEN
       Plant_text = plant_int_text
ELSE
       Plant_text = plant_ext_text

Ans:  b

No comments: