https://community.databricks.com/t5/data-engineering/shorten-query-run-time/m-p/35502#M25903 <P>Challenges in query long run time; what are the recommended steps to improve performance&nbsp;</P> Wed, 28 Jun 2023 00:45:52 GMT JLL 2023-06-28T00:45:52Z https://community.databricks.com/t5/data-engineering/shorten-query-run-time/m-p/35502#M25903 <P>Challenges in query long run time; what are the recommended steps to improve performance&nbsp;</P> Wed, 28 Jun 2023 00:45:52 GMT https://community.databricks.com/t5/data-engineering/shorten-query-run-time/m-p/35502#M25903 JLL 2023-06-28T00:45:52Z https://community.databricks.com/t5/data-engineering/shorten-query-run-time/m-p/36894#M26208 <P>The question needs more precision : is it the cluster startup that takes a while ? If yes, try serverless warehouses</P><P>Are there many queries running in parallel and that is where you see a slow down ? Each cluster can only run 10 queries in parallel, so in that case you might need more clusters.</P><P>Overwise, maybe just increase your cluster size, or refactor your query. Check what step is taking a long time by going to Query History and see each steps performed by the clusters.</P> Tue, 04 Jul 2023 06:41:41 GMT https://community.databricks.com/t5/data-engineering/shorten-query-run-time/m-p/36894#M26208 erigaud 2023-07-04T06:41:41Z