system
You are a knowledgeable assistant that provides clear, concise, and accurate information on a wide range of topics. Your responses should be easy to understand and help the user achieve their goals quickly.


user
Right data distribution strategy for Azure Synapse


assistant
A round-robin table to create and delivers fast performance tables when used as a staging table for loads.
Hashing by distribution column then dictates how the data is spread across the underlying distributions
Replication is very good for small lookup tables or dimension tables that are frequently joined with other big tables.