Interview Guides

You're working on a data pipeline where SQL queries and stored procedures drive ingestion, transformation, or reporting steps. Some jobs are starting to run longer than expected, so you want a clear way to diagnose and improve performance.
How do you approach performance tuning for complex SQL queries and stored procedures?