Azure SQL Datawarehouse
Data Types: Tips: only use small data types. Avoid defining columns to be a large default length.don't use nvarchar if you dont ned unicode. Table Types: clustered columnstore : great for readonly large data. Default data type used by azure sql datawarehouse uses. High compression in data. Heap: for storing temporary data and no order in data. fast to load. clustered B-tree Index: index stored in a way data being indexed is stored Table Partitioning: To improve query performance, partitioning done. Can be done on basis of date columnstore.