u/Severe-Coconut6156

I'm curious how teams are dealing with query performance over time as applications evolve.

A few questions I'd love to hear your experience on:

\- How do you identify queries that need to be rewritten?

\- How do you ensure schema changes (indexes, partitions, column changes, etc.) don't negatively impact production?

\- Is this mostly a manual process, or do you use any tools to analyze query patterns and recommend improvements?

\- Have you ever had an outage or major performance issue because a query or schema change wasn't optimized?

I'm exploring this space and trying to understand whether this is a pain point worth solving. I'd really appreciate hearing about your workflows, the tools you use, and what's still frustrating today.