Compose for Data Warehouse: Version 2021.8.0.372 using Azure Synapse Analytics.
Microsoft recommends adding FORCE_ORDER in queries which are resource intensive. FORCE_ORDER tells the optimizer to process the tables in the order they are listed in the query.
A LABEL tells the Synapse resource manager which workload group to use. This is a benefit since our fact table INSERT statements are the most resource intensive ones of all the instructions. Additionally this will help to dynamically set a LABEL which will allow to control the amount to resources allocated to certain specific queries and we can further try to optimize our synapse experience with compose.
