4 ms·
How are people doing SQL without looking at query plans and table statistics? I just don't understand the problems people have with SQL or stored procedures.
by protomyth 5y ago
How are people doing SQL without looking at query plans and table statistics? I just don't understand the problems people have with SQL or stored procedures. Writing queries and proper table design are not that problematic.
Heck, we wrote a program at one point that dumped the operation being done by running queries. SQL is so much easier than a lot of other languages.
- ModernMech 5y agoSQL is one of those languages that found its way outside of developer circles. My father-in-law knows SQL, and he's just about as far as you can get from your stereotypical developer. SQL is much easier than a lot of other languages, but it means people who have no experience with the ins-and-outs of software development are going to use it. These users are guaranteed to employ the language in ways that are not "proper" but instead ad-hoc and problematic.
- kaba0 5y agoWell, if they write one-off queries, it doesn’t really matter. The problem is when developers write bad queries that are often executed.