Nonclustered, In-Memory, & XML Indexes

SQL Server 2016    |    Intermediate
  • 9 Videos | 46m 36s
  • Includes Assessment
  • Earns a Badge
Likes 19 Likes 19
Columnstore indexes work differently from traditional indexes in SQL Server 2016. Explore columnstore performance considerations that can impact operations, nonclustered indexes, in-memory indexes, and XML indexes.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • Playable
    1. 
    Clustered vs. Nonclustered Columnstore Indexes
    5m 16s
    UP NEXT
  • Playable
    2. 
    Creating a Nonclustered Columnstore Index
    4m 8s
  • Locked
    3. 
    Changing Data in a Nonclustered Columnstore Index
    3m 37s
  • Locked
    4. 
    In-memory Nonclustered Hash Indexes
    7m 44s
  • Locked
    5. 
    Creating Tables with Nonclustered Hash Indexes
    6m 57s
  • Locked
    6. 
    Performance Considerations
    4m 32s
  • Locked
    7. 
    XML Indexes
    3m 55s
  • Locked
    8. 
    Secondary XML Indexes
    2m 20s
  • Locked
    9. 
    Performance Considerations
    3m 37s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 28 Likes 28  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 26 Likes 26  
Likes 38 Likes 38  
COURSE Triggers
Likes 32 Likes 32