AI, Data Science & Business Certificates from Google, IBM & Microsoft
Learn Backend Development Part-Time, Online
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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