Earn Your CS Degree, Tuition-Free, 100% Online!
2,000+ Free Courses with Certificates: Coding, AI, SQL, and More
Overview
AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off
One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.
Unlock All Certificates
Explore common strategies for enhancing performance in Delta Lakehouses in this 31-minute video from Databricks. Learn techniques to improve query performance for data analysts, including data skipping, index column optimization, string handling, Z-Order optimization, SQL partitioning, and Delta Cache management. Dive into the Delta Architecture pattern and its Silver layer, and understand multidimensional curves. Watch a practical demonstration of these concepts to gain insights on analyzing queries and implementing performance-boosting measures for your Delta tables.
Syllabus
Introduction
Data skipping num index columns
Moving long strings
Optimizing Z Order
SQL Partitions
Delta Cash staleness
Delta Architecture
Silver
Multidimensional curves
Demonstration
Taught by
Databricks