Optimize data warehouse query performance in Azure Synapse Analytics

Intermediate
Data Engineer
Synapse Analytics

Learn the techniques that you can use to optimize query performance within Azure Synapse Analytics.

Learning objectives

In this module, you will:

  • Understand performance issues related to tables
  • Understand table distribution design
  • Use indexes to improve query performance
  • Create statistics to improve query performance
  • Improve query performance with Materialized Views
  • Use read committed snapshot for data consistency
  • Optimize common queries with result-set caching

Prerequisites

  • Before taking this module, it is recommended that you complete Data Fundamentals.