What conditions are necessary for a SELECT * query to be faster than a SELECT field1, field2 ... query, other things being equal?

Question

SQL

Are there conditions where a view request
SELECT * FROM Table
is faster than
SELECT field1, field2, ... fieldX FROM Table
if both requests take the same amount of data?

Answer 1

Are you too lazy to list the fields or what? If you need all the fields from 1 table, yes, it seems easier with an asterisk. However, if you make at least some JOIN - the asterisk will become a source of unnecessary load, bugs and unexpected behavior.

Answer 2

Isn't it logical that equal volume can only be when you enumerate all fields...