https://community.databricks.com/t5/data-engineering/explaining-the-explain-plan/m-p/86255#M37305 <P>Hi All,</P><P>I am new to Databricks and have recently started exploring databricks' explain plans to try and understand how the queries are executed (and eventually tune them as needed).<BR />There are some things that I can somehow "guess" based on what I know of other platforms' (e.g. teradata, presto) explain plans, but I was wondering if there is an official documentation or tutorial on how to interpret the different operators and steps used in the databricks' explain plan?<BR />I saw this page on photon:&nbsp;<A href="https://docs.databricks.com/en/compute/photon.html" target="_blank" rel="noopener">https://docs.databricks.com/en/compute/photon.html</A>&nbsp;which enumerates the different operators. I was wondering if there is a document with a more detailed explanation though</P><P>Any input or guidance on where i should start, to start understanding databricks' explain plans would be appreciated!</P><P>Thanks friends <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P> Thu, 29 Aug 2024 09:55:11 GMT annetemplon 2024-08-29T09:55:11Z https://community.databricks.com/t5/data-engineering/explaining-the-explain-plan/m-p/86255#M37305 <P>Hi All,</P><P>I am new to Databricks and have recently started exploring databricks' explain plans to try and understand how the queries are executed (and eventually tune them as needed).<BR />There are some things that I can somehow "guess" based on what I know of other platforms' (e.g. teradata, presto) explain plans, but I was wondering if there is an official documentation or tutorial on how to interpret the different operators and steps used in the databricks' explain plan?<BR />I saw this page on photon:&nbsp;<A href="https://docs.databricks.com/en/compute/photon.html" target="_blank" rel="noopener">https://docs.databricks.com/en/compute/photon.html</A>&nbsp;which enumerates the different operators. I was wondering if there is a document with a more detailed explanation though</P><P>Any input or guidance on where i should start, to start understanding databricks' explain plans would be appreciated!</P><P>Thanks friends <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P> Thu, 29 Aug 2024 09:55:11 GMT https://community.databricks.com/t5/data-engineering/explaining-the-explain-plan/m-p/86255#M37305 annetemplon 2024-08-29T09:55:11Z