Last post Jan 21, 2015 10:03 PM by Edwin Guru Singh
Jan 21, 2015 08:27 AM|Nishantg|LINK
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 Select statement can be improved, if yes then please let me know the steps?
I already created physical and in-memory table and both are giving me same result.
Jan 21, 2015 10:03 PM|Edwin Guru Singh|LINK
As per your case, the following link which may give you some ideas :