---
title: "Distribution Strategy for Azure Synapse"
canonical: "https://docs.vaultspeed.com/space/VPD/3291316569/Distribution%20Strategy%20for%20Azure%20Synapse"
format: markdown
---
On Azure Synapse it is best to specify some distribution settings for the overall performance of loading and querying your data.

You can specify the distribution settings for Synapse tables in VaultSpeed on the apply DDL settings window. A best practice is to specify a setting per layer.

![image](media://2f7a9a90-93b2-4769-8f3a-9a8d72164904)

![image](media://0533dc4e-b633-4c5a-9110-8e69e0a65215)

 Below is a starting point that we at VaultSpeed use for Synapse projects.  You can create different presets for the different distributions and apply them to the correct Vault Layer/Object Type in the Apply DDL Settings Screen

|  |  |
| --- | --- |
| **Vault Layer** | **Index & Distribution** |
| EXT DISTRIBUTION | HEAP, DISTRIBUTION = ROUND_ROBIN |
| STG DISTRIBUTION | HEAP, DISTRIBUTION = ROUND_ROBIN |
| FL HUB DISTRIBUTION | CLUSTERED COLUMNSTORE INDEX, DISTRIBUTION = HASH(OBJECT_H_KEY) |
| FL SAT DISTRIBUTION | CLUSTERED COLUMNSTORE INDEX, DISTRIBUTION = HASH(OBJECT_H_KEY) |
| FL SAT_TEMP DISTRIBUTION | HEAP, DISTRIBUTION = HASH(OBJECT_H_KEY) |
| FL LNK DISTRIBUTION | CLUSTERED COLUMNSTORE INDEX, DISTRIBUTION = HASH(OBJECT_P_H_KEY) |
| FL LKS DISTRIBUTION | CLUSTERED COLUMNSTORE INDEX, DISTRIBUTION = HASH(OBJECT_H_KEY) |
| FL LKS_TEMP DISTRIBUTION | HEAP, DISTRIBUTION = HASH(OBJECT_H_KEY) |
| FL LND DISTRIBUTION | CLUSTERED COLUMNSTORE INDEX, DISTRIBUTION = HASH(OBJECT_H_KEY) |
| FL LDS DISTRIBUTION | CLUSTERED COLUMNSTORE INDEX, DISTRIBUTION = HASH(OBJECT_H_KEY) |
| FL LDS_TEMP DISTRIBUTION | HEAP, DISTRIBUTION = HASH(OBJECT_H_KEY) |
| FL REF DISTRIBUTION | CLUSTERED INDEX (PRIMARY_KEY), DISTRIBUTION = REPLICATE |