title: Join Considerations in Azure SQL Data Warehouse
body: <p>How should you design your Fact and Dimension tables too speed up joins on the new Azure SQL Data Warehouse?</p>
  
  <p>Would distributing the large fact tables by hash and replicating the smaller dimension tables help speed up the join or should indexing be the main consideration?</p>