------- The two queries below, which is more efficient? - Find The Answeres -->

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