SQL Server 2014 In-Memory OLTP. SELECT statement speed

342 Views Asked by At

I'm analyzing SQL Server 2014 In-Memory OLTP feature and faced to situation that SELECT statement elapsed time is identical between in-memory and physical tables.

I know that In-Memory feature mainly impacts insert/delete operations where no latching/locking take part.

But I'm interested why access time to RAM and physical disk is the same even without latching/locking in the case of reading data.

Can anyone give me logical answer to this and whether it cannot be improved ?

Thanks in advance.

0

There are 0 best solutions below