Hacker News new | past | comments | ask | show | jobs | submit login

Both Oracle and SQL Server have the advice to use a constant value on their documentation. Postgres used to advise the use of `*`, but looks like they improved their optimizer so it doesn't matter anymore.

It's not superstition. It's people that know deeply how a complex system works picking the option with the best set of side-effects.




Join us for AI Startup School this June 16-17 in San Francisco!

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: