Announcing Skill Me Up Live! Sign up today and save 60% on your first month using offer code LIVETRAINING at checkout.
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.
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 are where you can get hands on experience from what you have learned from lectures. You get to work in real time in virtual machines at your pace.