About this question
I am using Microsft SQL Server 2016. I have an SQL table with 140000 rows. It is used only for selecting data. I am trying to increase it's selection performance by making it In-Memory table (it is worth to mention that this is my first time using In-Memory tables). The results I am getting in SQL Server profiler are rather dissatisfying. Compared data of 'CPU', 'Reads' and 'Duration' columns: SELECT from In-Memory table has 'CPU' a bit higher, 'Reads' up to 10 times lower but unfortunately 'Duration' stays pretty much the same.
I've tried generating In-Memory OLTP migration checklist - the results were successful. Could You please tell me if this is a good use of SQL server In-Memory tables? Maybe I am doing something wrong since duration stays the same? What are sql server in memory table?
Thanks in advance!