Course details

Columnstore Indexes

Columnstore Indexes

Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level

Columnstore indexes work differently from traditional indexes in SQL Server 2016. This course covers how to implement columnstore indexes in SQL Server 2016, as well as the various columnstore performance considerations that can impact operations. This course also covers nonclustered indexes, in-memory indexes, and XML indexes. This course is one of a series of courses that cover the objectives for 70-762: Developing SQL Databases exam.

Target Audience
Database professionals responsible for implementing and maintaining SQL Server 2016


Expected Duration (hours)

Lesson Objectives

Columnstore Indexes

  • start the course
  • recognize when to use columnstore indexes
  • determine when to implement a columnstore index
  • create a clustered columnstore index
  • describe columnstore index data loading
  • describe columnstore versioned feature summary
  • improve columnstore index query performance
  • implement real-time operational analytics
  • describe columnstore index data warehousing
  • implement columnstore index defragmentation
  • differentiate between clustered and nonclustered columnstore indexes in SQL Server 2016
  • create a nonclustered columnstore index
  • change data in a nonclustered columnstore index
  • describe in-memory nonclustered hash indexes
  • create tables with nonclustered hash indexes
  • describe in-memory index performance considerations
  • describe XML indexes
  • describe secondary XML indexes
  • describe XML index performance considerations
  • implement and configure columnstore indexes
  • Course Number:

    Expertise Level