Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
SQL Server can do minimally logged inserts when certain conditions are met. This can improve performance and keep the transaction log from filling up. As stated in the SQL Server documentation , the conditions for doing this with a "insert into ... select" statement are:
TABLOCK
hint is specified for the target table.Is there a way to get Compose to add a WITH (TABLOCK) to the insert statement it generates? This would be particularly useful for loading staging and temporary tables. It could also be used then "optimized for initial load" is selected for the task.
Hi @dpurdy66 , you can manually edit the query via Compose by going to the DWH panel, Press and Hold "CTRL" button, click on "ETL Commands" (while holding "ctrl"), open the query you wish to edit, and click save once the changes are done. Kindly notice that you will be required to do same steps manually each time (for different queries) or whenever you regenerate the task
On the other hand, if you suggest adding this hint as a permanent one in Compose (as a product suggestion), then you can submit a feature request via Ideation. You may use belw link for additional help on how to submit FR:
https://community.qlik.com/t5/Knowledge/How-To-Submit-Feature-Requests-For-Qlik-Products/ta-p/171258....
Kind Regards,
Adam