You have 3 alternatives and feel free to use the one that you are comfortable with :
Follow the documentation to see an example for each use :
https://learn.microsoft.com/en-us/azure/databricks/optimizations/aqe#query-plans
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
How to check execution plan in data bricks
select * from cte
You have 3 alternatives and feel free to use the one that you are comfortable with :
Follow the documentation to see an example for each use :
https://learn.microsoft.com/en-us/azure/databricks/optimizations/aqe#query-plans
Hi Vineet,
Here is a good explanation of using the explain function in databricks:
https://www.advancinganalytics.co.uk/blog/2021/10/11/databricks-execution-plans
More information on the EXPLAIN function:
https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-qry-explain.html
When you ask Databricks to explain your query, it gives you a detailed explanation of how it's going to carry out your request. This helps you understand how fast or slow your query might be and if there are any places where it might get stuck.
If this is helpful please accept answer.