3 ms·
Until there's an automated way for a database to tell a developer that their particular query is running terribly because of some defacto reason there'll always
by gigatexal 10y ago
Until there's an automated way for a database to tell a developer that their particular query is running terribly because of some defacto reason there'll always be a need for a DBA to interpret and investigate, though, I wish it weren't so. I wish we could just treat databases as "dumb" stores of information that could be queried in n number of ways without issue. Some or most DB-as-a-service offerings will handle the mundane tasks of backing up, upgrades, etc. but I know of none that offer this DBA-like level of service where an automated tool can tell you exactly what's going wrong, basically take the context of your query and match it with the current execution plan and the underlying structure of the tables and your data (data types included) and tell you what is wrong. That'd be a huge innovation if it exists. And I'd be out of a job.