Hash indexing in In-Memory OLTP
In this video, I am going to talk about internals of hash indexing in Hekaton tables. You will be able to learn how these indexes work internally, how to create them with suitable bucket counts. This can help you to design and troubleshoot hash indexing issues in your SQL Server if you are using in-memory OLTP.
Chapters:
0:00 - Introduction
0:56 - Row structure
2:32 - Single hash index case
3:53 - Multiple hash index case
4:40 - Choosing right bucket count