Delphi-PRAXiS - SQL Server: key-value store table and hash index

Delphi-PRAXiS (https://www.delphipraxis.net/forum.php)

- Delphi-News aus aller Welt (https://www.delphipraxis.net/58-delphi-news-aus-aller-welt/)

- - SQL Server: key-value store table and hash index (https://www.delphipraxis.net/198484-sql-server-key-value-store-table-hash-index.html)

SQL Server: key-value store table and hash index

<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