<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
Weiterlesen...