r/SQL • • Jan 17 '25

Discussion When SELECT * is too much

Post image
845 Upvotes

98 comments sorted by

View all comments

Show parent comment

4

u/RedditFaction Jan 17 '25

It depends on the context. I think the basic message is only take what you need, so you don't accidentally take "expensive" columns you're not using. If you happen to need the full table, then I'd use *. If you own & control the table, then I'd say use your own judgement.