march, 2020

wed04mar5:30 PM6:30 PMI will speak at SQL Server ConferenceIn-memory OLTP - non clustered vs. hash index in Microsoft SQL Server5:30 PM - 6:30 PM CET darmstadtium Kongresscenter, Schlossgraben 1, 64283 Darmstadt, Germany



As part of the in-memory OLTP engine, Microsoft has introduced two new index types – the non-clustered hash and range index. Both indexes are fundamentally different from the on-disk indexes, and both indexes serve a different purpose in an in-memory database. In this session (Level 300), we will look at the two in-memory index types to understand how they are constructed and when the non-clustered hash index is preferable to the range index, and vice versa.


(Wednesday) 5:30 PM - 6:30 PM CET


darmstadtium Kongresscenter

Schlossgraben 1, 64283 Darmstadt, Germany