Columnstore Indexes

Database professionals responsible for implementing and maintaining SQL Server 2016


Expected Duration
93 minutes

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.


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

Nonclustered indexes

  • differentiate between clustered and nonclustered columnstore indexes in SQL Server 2016
  • create a nonclustered columnstore index
  • change data in a nonclustered columnstore index

In-memory Indexes

  • describe in-memory nonclustered hash indexes
  • create tables with nonclustered hash indexes
  • describe in-memory index performance considerations

XML Indexes

  • describe XML indexes
  • describe secondary XML indexes
  • describe XML index performance considerations

Practice: Implementing Columnstore Indexes

  • implement and configure columnstore indexes





Multi-license discounts available for Annual and Monthly subscriptions.