They said the query performance would make you lose your mind. Instead, your query performance has suffered since moving to Azure Synapse Dedicated Pools. In this demo heavy session, we will cover the basics of effective MPP table design, including table distribution choices such as round-robin, hash, and replicated. We will also learn to how to interpret DSQL query plans and how to understand some common causes of underperforming queries in a MPP Environment including data movement, data skew and over partitioning.
Attend this session and make sure you and your Synapse Dedicated Pool queries have a good time.