Post

Reasons why SELECT * is bad for SQL performance: An old blog (with Oracle-specific examples) with a whole range of reasons why. It's not only about network traffic and SQL plan execution, but client side processing and memory usage as well. tanelpoder.com/posts/reason...

Jon Stone

@socialmediahandle.bsky.social

13 Mar

Dont they say, "never do that" at school?. I would think this would simply get rejected on most decently configured production db. Like it would bounce back and tell your manager?

Tanel Poder

@tanelpoder.com

Yeah, I once proposed a database "strict mode" configuration parameter when talking to Oracle development folks, which would simply reject (with an ORA- error) or log a warning about any bad practices it sees in App-DB interaction (like directly comparing VARCHAR2 to a NUMBER bind var datatype etc).

13/3/26, 2:02 pm1 repost2 likes

No replies yet.