ADF Pipeline & SQL Fix

I have a production-support ticket that I need to close quickly. The Azure Data Factory pipeline is taking too much time to run when it reaches the step that calls a SQL script, and the underlying issue appears to be performance-related within that script... (Budget: ₹1500 - ₹12500 INR, Jobs: Azure, Cloud Computing, Data Integration, Data Management, Data Processing, Debugging, ETL, Performance Tuning, SQL, Troubleshooting)