Water is limited to cooking food at its boiling point of 100 C (212 F), after that is becomes steam.
Oil has a much higher boiling point and can raise the temperature of the food well beyond that, typically 175 C (350 F). This enables different kinds of chemical reactions that give deep-fried foods their unique flavor and texture.
Latest Answers