Re:Why SELECT * is bad for SQL performance (2020)
by edroche on Monday February 15, 2021 @12:10PM
(#26144635)
I've always wondered why SQL didn't have something like an EXCLUDE clause to make this easier for tables with lots of columns where you wanted a large number of them in the result. Something like (table with columns a through z):
SELECT * EXCLUDE g, m, p, x FROM table