Exercise 4 - High Performance Analysis with Azure Synapse SQL Pools

solliancenet / azure-synapse-analytics-day

191 stars 241 forks source link

Closed srushti-714 closed 3 years ago

srushti-714 commented 4 years ago

The SQL Query takes execution time greater than 15 secs for wwi_perf.FactSale_Fast table and wwi_perf.FactSale_Slow .

And sometimes wwi_perf.FactSale_Fast table takes more execution time compared to wwi_perf.FactSale_Slow table

Is it something related to SQLPool DW size?

dakhoff commented 4 years ago

Thats because customerkey 0 has 30M rows. And other distributions has less than 200K rows