Tanel Poder personal blog
Why SELECT * is bad for SQL performance (2020)
Here’s a list of reasons why SELECT * is bad for SQL performance, assuming that your application doesn’t actually need all the columns. When I write production code, I explicitly specify the columns of interest in the select-list (projection), not only for performance reasons, but also for application reliability…
- Points
- 259
- HN comments
- 164
- Submissions
- 1
- Cited by
- 0 commenters
Databases & DataSoftware Engineering2021
On Hacker News
| Submitted | Title on HN | Points | Comments |
|---|---|---|---|
| Feb 15, 2021 | Why SELECT * is bad for SQL performance (2020) by wheresvic4 | 259 | 164 |
