Databases return exactly what you ask for.SELECT * forces unnecessary IO, memory usage, and network transfer.
SELECT OrderId, OrderDate, TotalAmount FROM Orders WHERE CustomerId = 42;
Cause → Effect
-
Extra columns → wider rows → slower queries
-
Explicit columns → faster reads + stable schemas
Bonus: Schema changes won’t break consumers.