21
We saw the same issue, fixing the partition filter dropped runtime 60%.
Migrated stacks last quarter and this regression appeared. Stack trace and plan attached:
Context: Synapse dedicated vs serverless for ad-hoc analytics
Happy to share schema snippets or metrics if useful.
We saw the same issue, fixing the partition filter dropped runtime 60%.
Start with the execution plan, numbers beat guesses.
Tried that, partial improvement but lag still spikes on redeploy.
Prefer a staging table plus validation gate before promoting to prod tables.
Note that merge on Delta still needs unique keys defined correctly.
Consider DuckDB or Polars for this size before spinning up a cluster.
Start with the execution plan, numbers beat guesses.
Sign in to reply.
© 2026 Lakebench, operated by Hunnurji Rao. Bengaluru, Karnataka, India.
No cluster. No install. Just the tab.