https://community.qlik.com/t5/Talend-Studio/How-to-avoid-costly-repeated-compilations-of-SQL-execution-plans/m-p/2312266#M83232 <P>The SQL Server creates a new execution plan for each new job start for an update statement because the parameters from the Talend job are not adopted and the queries differ each time. How can I avoid this? I want the same query to be used every time and no new one to be created because the smallest changes have crept in. </P><P></P><P></P><P></P><P></P> Fri, 15 Nov 2024 22:45:07 GMT mleczec 2024-11-15T22:45:07Z https://community.qlik.com/t5/Talend-Studio/How-to-avoid-costly-repeated-compilations-of-SQL-execution-plans/m-p/2312266#M83232 <P>The SQL Server creates a new execution plan for each new job start for an update statement because the parameters from the Talend job are not adopted and the queries differ each time. How can I avoid this? I want the same query to be used every time and no new one to be created because the smallest changes have crept in. </P><P></P><P></P><P></P><P></P> Fri, 15 Nov 2024 22:45:07 GMT https://community.qlik.com/t5/Talend-Studio/How-to-avoid-costly-repeated-compilations-of-SQL-execution-plans/m-p/2312266#M83232 mleczec 2024-11-15T22:45:07Z