Hi All,
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).
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?
I saw this page on photon: https://docs.databricks.com/en/compute/photon.html which enumerates the different operators. I was wondering if there is a document with a more detailed explanation though
Any input or guidance on where i should start, to start understanding databricks' explain plans would be appreciated!
Thanks friends ๐
