Reasons why SELECT * is bad for SQL performance - Tanel Poder Consulting
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 reasons. For example, will your application’s data processing code suddenly break when a new column has been added or the column order has changed in a table? - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training.