2 ms·
That sounds more like an ops problem than a business one. I’ve worked with a number of a non-technical roles that dabble in SQL, and it’s almost always they are
by nemothekid 7y ago
That sounds more like an ops problem than a business one. I’ve worked with a number of a non-technical roles that dabble in SQL, and it’s almost always they are querying a data warehousing solution (e.g Redshift, Pig, BigQuery) that doesn’t support indexes to begin with and most times just have to live with the performance.
It’s not their job to optimize the database, and it’s no different from seeing that a dev pushed a new feature that causes bad performance as well
- anbotero 7y agoIt’s not their job to optimize the database, but it sure is to recognize the basic bottlenecks in their scripts. My training addresses things they have to take into account, and how to approach us when they think they need optimization to what they are doing. It’s just that some of them don’t do it. I made it so it’s part of their onboarding process, so they should know who to contact for these things, yet some of them start literally complaining instead of contacting the team that could help them out.