Explanation Table Type: Hash distributed. Hash-distributed tables improve query performance on large fact tables. Index type: Clusted columnstore Scenario: Mechanical Workflow has a named Table1 that is 1 TB. Large aggregations are performed on a single column of Table 1. References: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-distribute