3 ms·
I've spent most of my career working with teams that mostly write SQL code, at multiple companies. Except for very rare fringe cases, using "SELECT *" in produ
by rrrrrrrrrrrryan 3y ago
I've spent most of my career working with teams that mostly write SQL code, at multiple companies.
Except for very rare fringe cases, using "SELECT *" in production code is universally considered bad practice.
- OoooooooO 3y agoSelect * is pretty standard for wide table queries like they are used in Data Analytics teams regularly. Because you really want ALL columns, even new ones without going back to fix all 300+ dashboards.
- chaps 3y agoYep. I think the others commenting here aren't using SQL for analytics and don't recognize the importance of select * in that context.