Azure SQL DW中的表 [英] Tables in Azure SQL DW

问题描述

大家好，

最近，我开始从事Azure SQL DW的工作，但是我对表设计的基本查询很少，请分享您的想法

Recently I started working on Azure SQL DW and i have few basic queries regarding table design, please share your thoughts 

1-默认值是什么仅具有聚集索引或堆表的表的数据分布类型

2-在这种情况下，我们应该创建一个(堆)或(一个带有简单聚簇索引的表).

3-是否有任何查询来查找数据分布(无论是Round Robin，Hash还是Replicated)?给定表

1- What will be the default  data distribution type for a table with only Clustered index or Heap table

2- Under which scenario we should create a (heap) or (table with simple clustered index).

3- Is there are any query to find the data distribution (Whether its Round Robin, Hash or Replicated)  for a given table

谢谢

Sarthak

推荐答案

嗨萨尔塔克

1.默认数据分发为round_robin，默认索引为集群列存储"索引

1. Default data distribution is round_robin and default index is Clustered Columnstore index

2.您可以在ETL流程的初步中间阶段创建用于暂存表的堆表，在此阶段中，该表正在准备进行转换，然后通过索引添加到主表中.您的小尺寸表可能会更好 聚集索引，因为它们没有足够的记录来进行有意义的列存储段划分，但还取决于工作量.查看https://docs.microsoft.com/zh-CN/azure/sql-data-warehouse/cheat-sheet和https://docs.microsoft.com/zh-CN/azure/sql-data-仓库/sql-data-warehouse-最佳实践

2. You may create heap tables for staging tables in a preliminary-intermediate stage of your ETL process where the table is then being prepared for transformation and then added to main table with index. Your small dimension table may be better off with Clustered Index because they don't have enough record to make meaningful columnstore segment but also depending on workload. Look at https://docs.microsoft.com/en-us/azure/sql-data-warehouse/cheat-sheet and https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-best-practices

3.

这篇关于Azure SQL DW中的表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！