Optimize data warehouse query performance in Azure Synapse Analytics

Optimize data warehouse query performance in Azure Synapse Analytics

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

Data Engineer
Synapse Analytics

Module 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

Units

Prerequisites

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