Forum Discussion

Scott_Powell's avatar
Scott_Powell
Advocate IV
2 years ago

Lakehouse SQL endpoint performance tuning

Hi - I'm curious to know if there is any way to see an "explain plan" or otherwise determine why a SQL query against a Lakehouse is taking a long time, and what could be done to help it. In my case I...
data engineering
Scott_Powell's avatar
Scott_Powell
Advocate IV
2 years ago

hi v-cboorla-msft in my case I was specifically talking about a Lakehouse not a Warehouse (using the SQL endpoint). I'll try a similar test on a Warehouse to see if that makes a difference. Overall I'm just really trying to judge the performance to see if it's reasonable or not.

 

Thanks!

Scott

v-cboorla-msft's avatar
v-cboorla-msft
Microsoft Employee
2 years ago

Hi Scott_Powell 


Following up to see on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.


Thanks