Completed
When to Use: In-Memory Indexes Only on memory-optimized tables
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Index Internals - RowStore, ColumnStore, and NoStore
Automatically move to the next video in the Classroom when playback concludes
- 1 Intro
- 2 Technical Assistance
- 3 Kalen Delaney Bio
- 4 Precon Abstract
- 5 Session Overview
- 6 Rowstore Indexes
- 7 B-Trees
- 8 What is in the Leaf Level?
- 9 When to Use: Disk-based B-Tree Indexes
- 10 Segments and Rowgroups
- 11 Columnstore Index Basics
- 12 When to Use: Columnstore Indexes
- 13 In-memory Indexes (Nostore)
- 14 Why In-Memory OLTP?
- 15 Hash Indexes
- 16 When to Use: In-Memory Indexes Only on memory-optimized tables
- 17 Comparisons
- 18 Fragmentation
- 19 Statistics
- 20 Maintenance
- 21 Session Summary Rowstore
- 22 Like What You've Heard?
