Welcome to the 21st video in our Synapse Espresso series!
In this video, Stijn discusses the benefits you get from optimizing your Delta tables using the Optimize command with ZOrder Indexing from the new Spark runtime 3.3. This video includes the general explanation of what is happening and showcases the performance gains your receive after implementing it!
Azure Synapse Spark runtime 3.3 : https://learn.microsoft.com/en-us/azure/synapse-analytics/spark/apache-spark-33-runtime
Optimize Command : https://docs.delta.io/latest/api/java/io/delta/tables/DeltaOptimizeBuilder.htmlZOrder Indexing: https://learn.microsoft.com/en-us/azure/databricks/delta/data-skipping
Stijn Wynants - Fasttrack Engineer https://www.linkedin.com/in/stijn-wynants-ba528660/
https://sql-stijn.com/
https://twitter.com/SQLStijn
#azuresynapse #serverless #sql #analytics #PerformancePoint
