Currently, we have a long time running issue for a data warehouse job, so we decided to optimize some stored procedures. After analyzing the stored procedures. we have some findings regarding the sql optimization. 1. Use the temporary table to minimize disk access. From the sql tuning view, the main concern for the database applications is to minimize disk access. Try […]