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.
Learning 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
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