Forum Discussion
Lakehouse query performance problem
I ran the same query on lakehouse sql endpoint with three different capacity with sku 2, 8 and 32 respectively but the query time remained unchanged 15 seconds. Doesn't scalability affect query time...
Hi Anonymous ,
the query was simple
Select *
FROM Table
WHERE column LIKE '%XXXXXX%'
so I don't see possible optimizations.
The table was deliberately voluminous, tens of millions of lines.
So why increasing capacity does the query time stay the same?
In Azure synapse pools (Dedicated and Serveless) this does not happen.
So I think there is a scalability issue for both the lakehouse and the microsoft fabric warehouse
Hi Marco,
You can try to enable / change VORDER for your table:
delta-optimization-and-v-order
Cheers,
M