The two queries below, which is more efficient?
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
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
Post a Comment