This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Thank you Amira Bedhiafi
Hello Vineet,
If this answers your question, please consider accepting the answer by hitting the Accept answer and up-vote as it helps the community look for answers to similar questions
Let's say we have query Select col1 fom table1 join table2 on col1=col1 order by then which query will run first
for you above quesiton, first tables are joined, then the columns specified in the SELECT clause are selected.
finally results are sorted based on "order by"
i did not understand how it works first it will take order by or group by or aggregation query.. I know sql server plan
suggestion pls
What do you want to understand exactly ?
Which order it runs first aggregation, order by, group but or select columns
In Databricks, or any SQL-based data processing system, the order of operations when executing a SQL query generally follows this sequence :
Can you please close the question and open a new one if you have other things to ask about?
No. It is starting with order by or group clause... Can you check once... Happy to close after purpose is resolved
What is your source? But your purpose in the question is about checking the execution plan in the query you provided and not the logical query processing in Databricks.
Source is CSV and it is Delta table
Can you gather everything in one question ?
I can say that we provided you with the answer for your initial question.
that's all i said is above
Do you consider this as a complete question with all details ?
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.