3 ms·
But that argument only holds true of you rely on the column order. Most modern applications just specify column names where this doesn't matter. A lot of best
by GekkePrutser 6y ago
But that argument only holds true of you rely on the column order. Most modern applications just specify column names where this doesn't matter.
A lot of best practices from 20 years ago are no longer valid. Like the excessive normalisation. These days data storage isn't always the major limiting factor anymore, in many cases it's better to have less tables with more data.
- deleted 6y ago[deleted]
- Mauricebranagh 6y agoWell if your specifying columns your not by definition doing a select *
- GekkePrutser 6y agoI meant specifying columns during extraction of the rows. Like using name=result_row("name") instead of name=result_row(1) The former works even with SELECT * irrespective of the order of the columns. The latter won't.