https://community.databricks.com/t5/data-engineering/explaining-the-explain-plan/m-p/86284#M37308 <P>Hi <a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/118125">@annetemplon</a>&nbsp;,</P><P>There are plenty of resources about this topic but they are scattered all over internet <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P><P>I like below videos, pretty informative:</P><P><A href="https://m.youtube.com/watch?v=99fYi2mopbs" target="_blank" rel="noopener">https://m.youtube.com/watch?v=99fYi2mopbs</A></P><P><A href="https://www.google.com/url?sa=t&amp;source=web&amp;rct=j&amp;opi=89978449&amp;url=https://m.youtube.com/watch%3Fv%3DKnUXztKueMU&amp;ved=2ahUKEwiBx5uziZqIAxU49LsIHfdhJNg4ChC3AnoECAoQAQ&amp;usg=AOvVaw3jhpxkp7PCzThR-Xvbqort" target="_blank" rel="noopener">https://www.google.com/url?sa=t&amp;source=web&amp;rct=j&amp;opi=89978449&amp;url=https://m.youtube.com/watch%3Fv%3DKnUXztKueMU&amp;ved=2ahUKEwiBx5uziZqIAxU49LsIHfdhJNg4ChC3AnoECAoQAQ&amp;usg=AOvVaw3jhpxkp7PCzThR-Xvbqort</A></P><P>If you prefer text over video then:&nbsp;</P><P><A href="https://www.google.com/amp/s/www.advancinganalytics.co.uk/blog/2021/10/11/databricks-execution-plans%3fhs_amp=true" target="_blank">https://www.google.com/amp/s/www.advancinganalytics.co.uk/blog/2021/10/11/databricks-execution-plans%3fhs_amp=true</A></P> Thu, 29 Aug 2024 11:21:22 GMT szymon_dybczak 2024-08-29T11:21:22Z 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