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.
