Implementing Clustered Columnstore Indexing in Azure SQL Database
Lab
Advanced
1 h 10 m
2017-09-19
Lab Overview
In this lab, we will explore the use of columnstore indexes in Azure SQL Database. We will evaluate the performance improvements we get when we implement columnstore indexes on tables for with analytical workloads.

Related Learning Path(s):
Azure SQL Database and SQL DW
Objectives
  • Implement clustered columnstore indexes in Azure SQL Database
Pre-Requisites
  • Experience with SQL Server or Azure SQL Database
Exercises
In this exercise, you will examine the structure of heaps, clustered indexes and clustered columnstore indexes to better understand the pros and cons of clustered columnstores in Azure SQL Database

In this exercise, you will compare the difference in performance between a table with a clustered index and another table with a clustered columnstore index.

In this exercise, you will explore the behavior of columnstore indexes when performing typical data modifications, such as inserts and deletes on fact tables.

Real-Time Lab
Not Registered?
Create Account
Already Registered?
Login
What are Labs?

Labs provide a live environment to get hands-on experience using the same tools and services in the real world.


Learn More