SQL Server: key-value store table and hash index

Thema durchsuchen

Ansicht

Themen-Optionen

SQL Server: key-value store table and hash index

Ein Thema von DP News-Robot · begonnen am 6. Nov 2018

Antwort

DP News-Robot

Registriert seit: 4. Jun 2010
14.967 Beiträge

SQL Server: key-value store table and hash index

6. Nov 2018, 21:20

<div class="field field-name-body field-type-text-with-summary field-label-hidden view-mode-rss"><div class="field-items"><div class="field-item even">Hash indexes are used as entry points for memory-optimized tables; both features were introduced in SQL Server 2014. Let's look at index performance in scenario "key-value store".

Scenario and environment

The table store a significant volume (about 10 millions rows) of pairs key-value. The key is of integer type and the value is a random st