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
