It is widely recommended NOT to use
SELECT *. I understand this, as it is not a good idea to bring the entire row into memory, when only a few cells are needed.
Is it still bad to use
SELECT *when we want to read the entire row, or even 90% of it?
Isn't it benefitial when we read the whole row? In normal condition, the server needs to look for each cells in
SELECT col1, col2 FROMin order of the
SELECT. But in
SELECT *, it simply reads in order of columns? The later should be easier and faster!