Synapse Espresso: Things to Consider when Choosing Your Distribution Key
Welcome to the 18th video of the Synapse Espresso series! In this video, we are joined by Stijn and Artur to discuss distributed structures in Synapse and things to consider when choosing your distribution key. Because after all, choosing the right distribution key can save us from many performance problems.
Timestamps:
00:00:14 Introduction
00:00:31 What is the distribution key?
00:02:30 Good Distribution Example
00:03:26 Bad Distribution Example
00:04:05 Useful documentation
00:10:50 Summary
Stijn Wynants - Fast track Engineer
/ stijn-wynants-ba528660
https://sql-stijn.com/
/ sqlstijn
Artur Vieira - Principal Program Manager
/ amvieira
Links:
Distributed Tables Design Guidance - https://learn.microsoft.com/en-us/azu...
#azuresynapse #sql