HomepageData + AI Summit 2022 Logo
Watch on demand

DBA Perspective—Optimizing Performance Table-by-Table

On Demand

Type

  • Session

Format

  • In-Person

Track

  • Data Lakes, Data Warehouses and Data Lakehouses

Difficulty

  • Advanced

Room

  • Moscone South | Upper Mezzanine | 151

Duration

  • 35 min
Download session slides

Overview

DBA perspective - Optimizing performance table by table

As a DBA for your Organization’s Lakehouse, it’s your job to stay on top of performance & cost optimization techniques. We will discuss how to use the available Delta Lake tools to tune your jobs and optimize your tables.

We will cover:
Survey of performance tuning (expectations, architecture/design, joins, IO)
Delta transaction log - gaining insights for performance tuning and cost optimization
Top 3 tuning & maintenance tips
Table Health Check Tool
Delta Log is rich source of insight
Statistics are relevant in the era of the Lakehouse

Session Speakers

Douglas Moore

Databricks

See the best of Data+AI Summit

Watch on demand